Pop-Up Subform not linking to Main Form

[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.

 

[Gina Whipp]

ABradley,

It would help if we could see the code you using with the Command Button.
Sounds like you are missing the Link Criteria but without seeing the code I
would only be guessing.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Rick Brandt]

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.

"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.