Full Version: Linking main form to subform
UtterAccess Forums > MicrosoftŪ Access > Access Forms
pablotx
Folks,
Can 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.
jmcwk
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
ain Form:
tbl1
PktableID (Primary Key Autonumber)
etc.
Sub Form
tbl2
pkDetailID (primary Key Autonumber)
fktableID (Foreign Key to tbl1)
etc.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.