subform synchronization

[bkelly]

Windows XP, Access 2003, Neophyte Access user
I have walked through several tutorials but when applying subforms to my database the subform will not synchronize to the main for. The main form has two cascading combo boxes and the sub form is to display 9 rows where the foreign key matches the primary key from the table for the second combo box, Golf_Course_Index. I have set the master and child like fields. when the form is opened Access promptes for the value of Me.Golf_Course_Index. It has the value, but obviously I have not, um, instructed it properly.



How do I get my sub form synchronized with my main form.
I went through the attachments steps to post a zip of my database. I'll check after submitting this.

Edit, I neglected to say the problem form is frmHoleEditSaved, and it uses subform sfrmHoleEdit3.

[SoftwareMatters]

Hi,
In your subform recordsource you need to change this line:
[Me].[Golf_Course_Index]
to this:
[forms]![frmholeeditsaved]![Golf_Course_Index]

Regards
JD

[bkelly]

I have continued to mess around with the forms and made progress. In the sub form I clicked on it to get the sub form properties. In the Data tab, the one with Link Child and Master fields, the Source Object field was blank. I edited it to tbl_Hole_Data and when I saved, Access changed it to Table.tbl_Hole_Data. Now the sub form has the correct data.

But now I have a problem in that when the form opens, the sub form is a blank rectangle inside the main form. I see the name of the sub form just above it, and inside it at the top left I see Table.tbl_Hole_Data. All else is white. I cannot get Access to show the any of the controls within the sub form.

How do I force Access to show the controls wihting a subform?

Edit: I found the thread solved option somewhere once, but cannot find it again. I still have questions, but the purpose of the OP has been resolved.