Pop-Up Subform not linking to Main Form

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,

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

"ABradley" wrote in message
...
I have a subform - frmLawEnforcement - that is accessed on the main
orm -
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 wrote:

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.