Subforms - probobly an easy solution but...

[Mark]

can anybody help (urgently im affraid)

i have a database set up with one main form, and 6 buttons with forms beneth
the buttons.

What I need the database to do is to bring only the relating forms up under
the buttons when clicking - if no forms present then blank ready for data
entry

For examplple - i have a field in the main form and a field in each of the
sub forms which reads the same for example 1234

So the question is how do i make the sub forms only bring up matching
records or balnk if no records - have tried relationships - doesnt work

In conclusion - the main form and the sub forms have a field exactly the
same name - if i enter for example 1234 in the main form i want only the
records relating to that under the buttons to appear or blank if no records
there thats match 1234

Can anybody help as htis is driving me insane

 

[BruceM]

The subform control (the main form "container" for the subform) has Link
Master and Link Child properties. In form design view click the subform
control to select it, then click View >> Properties. Be sure you are
looking at a Property Sheet with Subform/Subreport in the title bar at the
top of the Property Sheet. Click the Data tab. If Link Master or Link
Child are blank, click the item on the Property Sheet, then click the three
dots to the right of the item. If the table relationships are set up
correctly Access will probably suggest the correct fields.
It Link Master and Link Child are not blank, and are not set to the linking
field, clear them and proceed as above.
There is no way of knowing what you mean when you say using relationships
"doesn't work", but note that you need proper relationships. If you are
still having difficulties, post your table structure and describe the
relationships.