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" <ABradley@discussions.microsoft.com> wrote in message 
news:6113A7D6-C477-44E3-821A-7BFDFE456E1E@microsoft.com...
>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.