Desktop

Ask something
Discussion Locked

Help with a MSAccess Form

0 helpful
3 replies

by joe

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,
I have a form/subform that I enter information into for project tracking. Is there a way to set up a query or another form that asks for a project name or customer name that when the enter key is pressed will bring up just the form/subform for that project instead of having to page through numerous projects to find the one I am looking for so that I can update information that is in the form/subform?

3 replies

by Member 18636374

There are many ways to do this. The easiest way (probably) is:

1. Open your existing form in design view.
2. From the ToolBox place a Command Button on the form.
3. When the wizard starts for the Command Button pick
- Record Navigation
- Find Record
4. Save and close the form.

Now when the user opens the form it will act the same as it did before but if they click the button they will be able to search all fields in the underlying table for the record they want to edit (account number, name, etc).

Good Luck,
Erwin

This discussion is closed to new replies.