MS Access: Forms / Search Form

Posted on 2011-04-27
Medium Priority
Last Modified: 2012-05-11
I need to turn this form "frmToolsLookUp" into a simple search form that will use the field "Tool_PK" as the search field to bring up the record related to that PK to display that record in the other fields.

See attached file.

Question by:James Coats
  • 2
  • 2
LVL 11

Accepted Solution

donaldmaloney earned 2000 total points
ID: 35479267
See attached MDB

One way to do this is by changing the Tool_PK to a combo box nd coding the on click


Author Closing Comment

by:James Coats
ID: 35479373
That workd perfectly, thank you now I know how to do this.
LVL 11

Expert Comment

ID: 35479969
Another one.

Look at form  frmlToolsLookUpAfterUpdate
I locked the data on this form so it cannot be updated
and see the "AfterUpdate" for Tool_PK
Less code and changes the recordsource.
It will show the last one used when it opens.


Author Comment

by:James Coats
ID: 35483581

Thank you very much, this was not necessary but is very much appreciated as it increases my knowledge in this area. I am going to be asking some more questions that concern linking tables in this form so that I can inspect an instrument and then link the child record to the record that was called up by the search.

I have linked the tables the way I think they should be but I am not seeing correctly linked. Again thanks for the extra info.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question