Query that feeds a form?

[Profector]

Someone one point me the right direction on this? Even help with just a couple of keywords for a google search would be helpful.

I have a form that I want to display the a certain record. I want the user to be able enter a sales order number and record that matchs that order to be displayed in the form. I have a query that does that but I dont know how get the query to populate the form without a box popping up to asking the user to input the order number. I was thinking something more like a button they could hit after they've entered the order number or perhaps the form could be populated after the textbox nolonger has focus.

Thanks for reading.

 

[MStef]

Try to do that via FILTER BY FORM, CLEAR GRID, APPLY FILTER and REMOVE FILTER icons.

 

[Profector]

Thanks for the hint. I ended up with



Dim mberror As Byte

If IsNumeric(Me.ReportNum) And Not IsNull(Me.ReportNum) Then

DoCmd.ApplyFilter , "fICANumber =" & ReportNum

Else

mberror = MsgBox("Enter a correct report number and try again!", vbOKOnly, "Error")

End If