Pop-Up Subform not linking to Main Form

  • Thread starter Thread starter ABradley
  • Start date Start date
A

ABradley

I have a subform - frmLawEnforcement - that is accessed on the main form -
frmCorporateSecurity - by clicking on a command button from the main form.
The two forms are linked by the CaseIDNumber field.

If I place the subform as just an entry from with the main form, the
information shows as linking by the CaseIDNumber. When I enter the
information into the subform using the command button, the information does
not link to the case number.

I am not sure what I could be doing wrong. I am an intermediate Access user
but am fairly limited on VBA.
 
ABradley said:
I have a subform - frmLawEnforcement - that is accessed on the main form
- frmCorporateSecurity - by clicking on a command button from the main
form. The two forms are linked by the CaseIDNumber field.

If I place the subform as just an entry from with the main form, the
information shows as linking by the CaseIDNumber. When I enter the
information into the subform using the command button, the information
does not link to the case number.

I am not sure what I could be doing wrong. I am an intermediate Access
user but am fairly limited on VBA.
Click to expand...

"subform" is a specific term used to describe a form that is embedded within
another using a subform control. If you are opening the second form as a
popup then it is not a subform and will therefore not behave as one.

All you are doing is opening a new independent form with a filter applied.
You are doing nothing to control how it behaves when you enter new records.

One can make a popup form behave pretty close to how a real embedded subform
does, but it takes extra work and setup than what the wizard provides.

Is there a good reason why you don't want to use an embedded subform? That
really is the best way to do it.
 
Back
Top