how to search for a record on another form if it is an autonumber field

[Ryno Bower]

Hi,*
I have problems to search for a record from another form.
*
I have a form called "Quote".* When I want to search for a quote there is a search button which opens another datasheet form with a list of all the quotes, and the first column (QuoteNo) is like a hyperlink.* So when I click on the specific quote no I want to go to on the "Quote" form it wont do the command.
*
The QuoteNo is a Autonumber field - I don't know if that is why?* I have done this in the past but with normal text fields and it worked.
*
This is the code*I used.
*
DoCmd.SearchForRecord acDataForm, "Quote", acFirst, "QuoteNo='" & Forms!QuoteHeader!QuoteNo & "'"
*
QuoteHeader is the for that opens with the list of quotes.
*
Could you please assist me in making this search work.
*
Thanks

[Mariostg]

When you search for a number type, you don't surround it with quotes ('12').
So Replace
DoCmd.SearchForRecord acDataForm, "Quote", acFirst, "QuoteNo='" & Forms!QuoteHeader!QuoteNo & "'"
with
DoCmd.SearchForRecord acDataForm, "Quote", acFirst, "QuoteNo=" & Forms!QuoteHeader!QuoteNo

BTW, I don't know where those asterisks come from in your text, but you should avoid using them. They are distracting when trying to understand your problem.

Cheers.