Need Help with Subform not displaying correctly

[khunter]

Subform linked to Main form (Help)

Hello,

I recently was introduced to access 2000 and have created an Engineer Change Request tracking database. I have one problem though, I cannot seem to have my subforms display only the relavant information that should be passed from the main form.

Both subforms in the attached db should only display the information that is relavant to the main form ECRID. Right now they show all records instead of the one that is currently used in the main form.

Any help would be much enjoyed

 

[Graham T]

khunter

You will need to go into the design of the main form, select each subform so that you can view the properties of subform tblModel and subform tblADC1.

You can then set the Link Child Fields and Link Master Fields to the relevant field (in both cases lngECRID)

Now when you view the form and scroll, the relevant records will be displayed.

Please see the attached

HTH

Graham

 

[Graham T]

Attached.....

 

[khunter]

Thanks

It seems like it is always the easy things that slip by me. Thank you for the great help.