Form Linking Question

[jazzscreamer]

I have a form called CaseLookUp. This form is opened in the Load Function of the Case form. CaseLookUp should be populated only with records belonging to a certain idNumber on the Case form. How do I make it so that this happens. If you have any question feel free to ask. Thanks,
Joel

 

[pono1]

Joel,

A nested subform should do it... Search here or in the Help file for instructions...

Regards,
Tim

 

[jazzscreamer]

Hi,
I know that this will work. But, how do I do it while still keeping my forms seperate? It seems that making my two forms nested subforms will make it so they are both on the same form. I'm looking for my CaseLookUp form to be a seperate form, not part of the Case form. Is there a way to do this?
Joel

 

[dcx693]

Use some code in the main form's On Current event to update the record display in the "subordinate" form. You can either filter the subform's recordsource or dynamically change the subform's recordsource. The code is something like:
Forms("CaseLookup").Filter=something
or
Forms("CaseLookup").RecordSource=something

The syntax of the something will depend on which method you choose.

 

[pono1]

Attached is an extremely rough sample. A place to start, perhaps.

Regards,
Tim