MS Access: Forms / Search Form

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.


Measuring-Instruments-4-26-11Rev.mdb
James CoatsComputer Info. Sys. StudentAsked:
Who is Participating?
 
Donald MaloneyConsultantCommented:
See attached MDB

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

Don
Measuring-Instruments-4-26-11Rev.mdb
0
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
Donald,
That workd perfectly, thank you now I know how to do this.
Sam
0
 
Donald MaloneyConsultantCommented:
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.

Measuring-Instruments-4-26-11Rev.mdb
0
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
Donald,

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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.