dlookup

[antonellac]

in a program i m working on i have
There are two forms.

Orders - Contains details from the table Orders
Ordersearch - Contains a textbox in which you are to input your search key and the order form is loaded with relevant details.

Order_Number is the field in the table Orders
OrderNo is the textbox containing the number in the Search Form



the code can be seen in the attachment available.
can someone tell me whats wrong pls
and try and correct it pls

 

[Pat Hartman]

You don't need the three DoCmd's, you only need the first - OpenForm. Just add a where argument to bring up the correct record.