Find Button

  • Thread starter Thread starter esleea
  • Start date Start date
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
 
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.
 
Back
Top