MS Access: Forms / Search Form

Posted on 2011-04-27
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
    LVL 11

    Accepted Solution

    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
    That workd perfectly, thank you now I know how to do this.
    LVL 11

    Expert Comment

    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

    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

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now