Subform Master Child prompt before defined

[virgilio]

Hi All,

I'm stuck while trying to open a new form from a button press. I'd like to open a form, lets call it "Input Form" from another form, "Main Form".

• Input form has a subform with a list of comments linked to a separate table, I'll call the subform "Comment Form".
• Comment form is linked to Input form by a field in both record sources called "BATCH", and both Master and Link Child fields are set to BATCH

When I click the button on the Main Form to open Input Form, I get a prompt to enter a value for BATCH and I can't for the life of me figure out why. It is clearly trying to link the subform "Comment Form" with the Input Form before I set the value of BATCH on the "On Open" event. I put a msgbox("here") statement at the top of the "On Enter" event, but I get prompted for BATCH before I get the "here" message.

What am I missing?



(Image of Input Form attached)

[ranman256]

is the table field actually called BATCH on both tables?
is the text box actually called BATCH on both forms?

[virgilio]

is the table field actually called BATCH on both tables? Yes
is the text box actually called BATCH on both forms? No, I'm not using the BATCH field on either form. I'm just using that field in the table to link Master and Child.

TBH, I'm using a previous project that I made about a year ago as a template and this works perfectly there. I just can't see what I'm doing wrong.

[Welshgasman]

Subforms load before mainforms?

[Micron]

Subforms open and load before the main form, so something in your code is causing this. If you can move that to the main form you should be OK.
Dang! Late to the party again.

[CarlettoFed]

Attach a sample file so you can see what you've made.

[virgilio]

I put a message box into the open event on the subform [MsgBox ("subform open")], and I still get prompted for BATCH before I get the "subform open" message.

[virgilio]

Solved, It looks like I just needed something in the Record Source of the Property Sheet for the Input form. It doesn't look like it is doing anything so I left it blank in the new version. IOW, The BATCH prompt quit when I filled Record Source in with a SQL query that is unrelated to the rest of the form. I guess Properties is being overwritten by VBA after everything is loaded.

Thank you all for your help.