Please help to create find record command

[crazdandconfusd]

I created a form based on one table and was able to find information using find record and searching entire form. Now I split the information into two tables: one for the front of a page to be printed and another for the back to be printed. Now when I search for information in the entire form and will only search the record displayed. I'm trying to search the main form and an inserted subform in datasheet view through all records. Please help as I'm new to the powers of Access and trying to avoid messing up my database since I had many trials and errors getting this far on my own.

[PEB]

Hi,

The search command offers you a possibility to search everything in the main form...

For the sub form it search it in the current main record!

To search in both do a query joining the two tables and than use the search functionnality!

Best regards!

:)