I have a form (Table 1 Child) that when inputting a specfic Number that i want it to pull information from another table (Table 2 Parent) into the form. Can this be done and what is the best way to do it?
I have a form (Table 1 Child) that when inputting a specfic Number that i want it to pull information from another table (Table 2 Parent) into the form. Can this be done and what is the best way to do it?
You can filter a continuous form that shows all records ,that filters down to what's in the box,
or,
Use the form as a parameter and open a query....
select * from table where [field]=forms!myForm!txtBox