Hi James.
>> I have two tables with a one to many relationship. when i am on the parent table record i want a combo box to show only the corresponding records of the child table. Is there a property to filter out non related records <<
How about setting the RowSourceType of the combo box to SQL and the RowSource to
SELECT Yada Nada Blah FROM SomeTable WHERE SomeField = ParentField INTO CURSOR MyCursor
Then, whenever the record changes in the parent table, all you have to do is
MyCombo.Requery()
Marcia
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only