creating search form

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

Guest

I need to create a form that will search records I have in a table. I want to have a text box where the user can enter the record id #. Then click a search button and the record and all of it's information is displayed in the bound text boxes.
 
There are several ways to do this...the easiest is probably this. Se
your forms recordsource to the table your data is in. Add a combobo
and select the 3rd choice in the wizard 'Find a record in
table/query'. Select the ID# field as the data you wish to display.
Next, select all the fields whose data you wish to display and plac
them in the form. Whenever you select an ID# all those fields wil
show the information for that record. If your data is spread ou
through more than one table, create a query for all the necessar
tables and base your form off that query.

Let me know if you need any more help.

Shine
 
You must log in or register to reply here.

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

Access Automatically Send a notification email once a record is added 0
Access Microsoft access database(creating a search engine form) 0
Search for a record by typing in a text box 3
Create a Search Box on a form 2
Access Sub form opens before the main form in MS Access 0
look up ID in a form 8
question boxes 2
Pop-up form that creates record that links 1:1 to main form 0

Back
Top