By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,299 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,299 IT Pros & Developers. It's quick & easy.

Please help to create find record command

P: 2
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.
Sep 27 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418

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!

Sep 30 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.