Opening a subfrom related to main form

[Lourry]

Hello All,

I have a command button "List ELement" and when I click on it, I would like it to open up a form in the same database which I have created and saved as name "Element". The main form "Code" is continuous which users can add to it and the subform "Element" is also continous and the data is saved on a different table than "Code". When the user clicks on the "List Element" button, I would like the form "Element" to show up and display all the records that match one of the text fields on "Code" form. How do I do this?

Thanks in advance!
-Lory

 

[pono1]

Lory,

If I catch your drift, then the answer is you should probably use a nested subform. Search in the Help file (or here) where there's step-by-step instructions for setting up your forms.

Regards,
Tim