textbox in form to open other form with specific record

[tweaver1]

I have a form with a text box. I want to be able to input the item number into that text box, and then click a button. When I click the button, I want to have another form that I have made that allows me to edit a record. I want this edit form to open up to the record that matches the item number from the previous form. I'm not sure where to start. any advice is greatly appreciated.

[pbaldy]

How about:

BaldyWeb wherecondition

[tweaver1]

DoCmd.OpenForm "Edit", , , "ID NUMBER = " & Me.Text6

That is what I have inserted, and it it giving me an error about a missing operator in query expression 'ID NUMBER = 53'

[pbaldy]

Because of the inadvisable space, you need to bracket the field name.

[tweaver1]

Ah alright, so I have bracketed it... now a box pops up asking for the number. I put it in, it opens the form, but doesn't go to the correct record.

[pbaldy]

If a parameter prompt comes up, Access can't find whatever it is specifying. Is that field in the form's source? Does it have a numeric data type?

[tweaver1]

ah yes, I changed the name of ID NUMBER to IDNUMBER and forgot to update that in the code. it works. Thank you very much

[pbaldy]

Happy to help.