Subforms missing ID #

[risoam]

I have a form that has a tab control and on each tab control "tab" I have a subform. The main form has a recordsource of a table that all of the subforms are dependent on. The main form has a hidden ID field that all of the queries for those subforms use as criteria. It works great for 4 out of the 6 tabs. For some reason, the last 2 subforms that I made are not seeing that hidden field ID, so when I go to add a new record I get an error because it always sees it as a 0 and not as a valid id #. The queries work fine, meaning they are depenednet on that hidden field and return the results that I would expect, but just when I try to add a record it isnt finding that ID to add to the table. Any ideas?

 

[DiamondDust]

Try using that Hidden control as some of the default values on the fields that are not able to read the hidden control value. Properties of the field then default value. This will be the value of any new records.

 

[risoam]

Good idea! That did the trick, thanks.