Form to search database and return found records (re-post)

K

kansaskannan

I have a query that pulls in required data from four tables. I then
created a form populated with fields from this query. To this form I
added a sub-form. The sub-form is based on the same query. Hence
there are two groups of the same fields (except that one group is
within a sub-form). The two groups are linked through the Link Master
Field and Link Child Field, such that when I press page-up/down in the
Master Field, the records in both groups change in a synchronized
fashion. (At this point, only one record is visible at a time in each
group).

I need to be able to fill in one form and have all matching records
returned in the other form.

Could anyone please advise how to do this? I would appreciate it very
much.

Thank you.

kannan
 
Top