want one button(find record-in main footer)to find focused variab.

[Guest]

Hi,

I have created a main form and a subform, now I want to use just one command
button in the footer of the main form to find records using any variables in
both main and sub form. At this point, the command I have in the footer of
the main form only works with the variables that belong to the main form.

Just to give you a background....

The main form is bounded to a table called 'facility contact' and the
subform is bounded to a table called 'coordinators'. I use a variable,
facility num, as the primary key and these two tables are joined together
using this primary key in a one to one relationship.

Thank you very much in advance.

 

[Guest]

Hi Shah:
If I understand you correctly, you have two tables with a one to one
relationship on FacilityNum the primary key in both tables. You would like to
display data from both tables and have them set up as form and subform.

If that is correct, my first question would be whether it's necessary to
have two tables. Assuming there is a reason to do that, you want to use
criteria in either the first or second table to select records?

Code for that could be complex. Could you provide a specific example of what
you are trying to do?
Sam