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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement