Need Help on Macro, really confused

[Athens]

Hi,

im putting together a database for a co-worker. and im a little bit stuck.
i have all the forms and everything that i want to use, but im having
trouble with linking them back to the main tables. all the forms are being
clicked on or opened from one main form.
for example:
i have a subform with only the name and firm field, and them i have a button
beside it that goes to the expanded form where you can fill in the rest of
the client information. The problem is, when you click on the button, it
doesnt go to the specific table id for the project. i.e. (CaseID) that is
being used to link all the info for the project.
How do i correct this? the button runs on an embedded macro. is there a way
of altering that macro, or creating another that goes to the proper CaseID?

 

[bhicks11 via AccessMonster.com]

Hi Athens,

YiaSou!

A subform should be synced to the main form. If the main form is showing the
correct CaseID, that's what should be shown on the subform. If you click on
the very upper right corner of the subform (so the corner box is not black)
you will be able to see the linked fields in the data tab of the properties.
Make sure that is correct.

If you need to further filter the subform based on the main form, in your
subform properties (with right corner box black) set the filter to what ever
you want on the form:

=caseid=forms!mainform.caseid

Is that clear as mud?

Bonnie
http://www.dataplus-svc.com