Subform Issues

  • Thread starter Thread starter briank
  • Start date Start date
B

briank

Background: Currently I have a form (frmMenu) that houses five bits of
criteria and when the user clicks the "run" button a popup form (frmMain)
opens in datasheet format (record ct: 5) with no problems. It was suggested
by my boss that I open frmMain in a same from as the criteria but in a
different tab. So now I have in frmMenu TabCtl175 which has two tabs:
Page185 which has the criteria and Page 186 which has the subform: frmMain.
Important to note is that frmMain's data is populated by a stored procedure.

Problem: When frmMain was treated as a popup form, it worked as planned.
When frmMain is put into a tab approach it doesn't seem to be connecting with
the criteria as the record count is over 500 (which in this example s/b 5).

Question: Any thoughts on how to make this subform approach work?
 
Brian,

When you inserted the frmMain into the main form, did you link the sub-form
and main form using the Parent Child links in the Form Properties?

If you did not, then that would explain your problem. If you did, then
maybe you did not link them using the correct fields. Just a guess. Let me
know.
 
Back
Top