Switchboard

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I have a switchboard which contains 3 options. (Open form,
Reports and Exit database). I want to add a 4 option
which will be to search the database for Last name. The
problem is that I have 8 reports that shows differents
sections of the database (with all the Last name
included). When I entered the search button to look in
the reports for a specific Last Name instead of looking
through all the reports (I have entered my criteria
as "Enter Last Name")it works fantastic, but when I go
through my reports all the information of my reports are
gone. What do I do wrong?

Please help.

Thank you

Michelle
 
All my reports have the right record source attached to
them such as different queries. I did the same for the
report attached to the Search option but I lose all my
information of all other reports when I use the Search
option. VERY VERY WEIRD! If I remove the criteria in the
Last Name field in the query, than all my reports are back
together. I want to ensure that I enter a criteria to
prompt the user to enter a last name.

Michelle
 
Back
Top