oening a form/record from a command button

[wilson1001]

Hello

I am creating a simple database to keep track of washing machine parts
I have a table and a form called ‘parts’.
My primary I.D field is ‘part no’

I have second form called ‘search’ with a textbox (txtfilter) and a command button (cmdsearch).
I want the textbox to accept the input of a part number. When the command button is clicked I want it to search the ‘parts’ table for the corresponding record open the ‘parts’ form and record so that it can be updated.

I know I could use a list box to display the results but I want to do away with that and open the ‘parts’ form with the correct record directly from pressing the command button.

I assume that I somehow need to create a statement that will search all the part number fields in my table and then store and pass that record on to the form?

Can anyone point me in roughly the right direction?

any help much appreciated
Thanks
Pete

 

[Rich]

The command button wizard will create the code for you.

 

[AncientOne]

Use a combo box, with its recordsource being your part numbers from the parts table. There is a wizard which prompts you for whether you want to display specific records when the combo is updated.

 

[wilson1001]

Rich

Unbelieveable! So simple and it works!

Thank you very much indeed.

Kind regards
Pete