Folks,

Ran into a problem today that I can't figure out. Should be an easy fix, but it has been years since I designed the database in question. Everything was working fine until yesterday and I can't find the solution.

Problem: Subform isn't opening with information from the main form unless I save main form information first. Attached is a very simple example. I want the subform to have the main form's information automatically.

Thanks in advance for the help.

Not to sure what you have going on there your attachment has 1 table a Main Form/ Subform UI would require a table and a sub table (table2) holding the detail records related to table1

Main Form:

tbl1
PktableID (Primary Key Autonumber)
etc.


Sub Form

tbl2
pkDetailID (primary Key Autonumber)
fktableID (Foreign Key to tbl1)
etc.