Creating a way to search or add new

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry if my question is elementary but I am a new user of Access:

I have already created a table with my data as well as a form to enter new
data. However, when the users open the db, I want something that asks them
whether they want to search the data that is already there or add new. When
they do the search, I would like to have specific search criteria like name,
report date, etc. Also, if they add new, I want a way to take them directly
to the form I created to add the new data. Would I create a new form with
the 2 command buttons of search and add new? How do I link it to the data
sheet I already have?

I would appreciate any help that is given!!
Erica M.
 
Create a form that has a button that opens a search form and a button that
opens an add new form. In the menu bar Tools, Startup, there will be a drop
down box called "Display Form/Page" select the form with those buttons. Your
application will now run that form when it opens allowing the user to search
or add new.

Good Luck!
 
Back
Top