Find Button

E

esleea

Hi,


I have a form (call this Aform) which lists results from a query; but
I also want to add a find option to the form so that the user can
just enter in the unique ID ( which is display on the result form).
When the user clicks find, it searches 6 other different types of
forms (more detail information on these forms). If it finds the ID,
it
opens the new form (Bform) and displays that record on Bform.


I tried DoCmd.OpenForm but I couldn't get it to work.


Thanks
 
G

Guest

You don't find data in forms. Forms are only to view and manipulate data.
All data is stored in tables. You can use queries to return data from one or
more tables or other queries.
You need to do your searching in tables or queries. Since you want to find
data in multiple tables, I suspect your application design needs some review.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find button to locate record in form and display that record 11
Access Sub form opens before the main form in MS Access 0
Parameters 5
Referring to controls on a form from a subform - weird issue 1
go to specific record based on choice in subform 2
Finding a Specific record problem 2
Auto increment Not Functioning Correctly 2
global forms? 1

Top