How do I create a search function that then takes you to the chosen record?

[Kmez]

I am very new to databases and am blundering my way though creating a new database and learning as I go so any help is appreciated.



I want to be able to create a 'start' screen in which the user has several choices. One thing I want to do on the 'start' screen is create a 'search' function in which the user can type in a surname or reference number and this then opens up the relevant record that they can view/amend.

How would I go about this?

Thanks

[Missinglinq]

By using a Combobox for each Field you want to use to search on. The Combobox Wizard will do most of the heavy lifting for you:

If you haven't already done so, create a form based on your table or query, including all the fields you want displayed. Then simply:

1. Add a Combobox to your Form.
2. The Combobox Wizard will pop up
3. Select "Find a record based on the value I selected in my combobox."
4. From the Table or Query the Form is based on, click on the Field you're searching by (a Field that is unique for each Record) to move it to the right side.
5. Hit Next.
6. Size the column appropriately.
7. Hit Next.
8. Name the Combobox something appropriate.
9. Hit Finish.

Now you can drop the Combobox down and scroll down to the item to search by, or you can start to enter the item, and the Combobox will "autofill" as you type. Hit <Enter> and the record will be retrieved.

If you want the Form to be blank when it first opens, use this code to move to a New Record:

Private Sub Form_Load()
 DoCmd.GoToRecord , , acNewRec
End Sub

Linq ;0)>

[Kmez]

Thanks missingling, that's really helpful.

However, how do I set up a combo box that relates to a field in a different table? Is this possible?

Thanks!