Pull in previously saved data to update based on number entered in one textbox

[Access Knowledge]

This is a customer service form to record who, what and when in a database. I have a form entitled "Service Record" for this. On it their are multiple combobox and textboxes as well as autofilled textboxes depending on some of the comboxes. At the very top there is a basic textbox to enter the "Sales Order Number". There is a box for the "Issue" and then the "Solution. At first I would like the employees to enter all of the information on the form except for the "Solution". Later I want to revisit this customer service record by typing in the sales order number and having everything pulled back into the form to either update or finish filling it out. Is there a way to do this and how?



Thank you for any help!

[aytee111]

When a sales order is entered, filter the form by putting into the AfterUpdate event of the sales order field:
Me.Filter="SalesOrder=" & Me!SalesOrder (whatever the fields are called)
Me.FilterOn=True

This will populate the bound fields from the record source.

[Access Knowledge]

I'm sorry I played around with this and couldn't get it to work. I tried your code with an "AfterUpdate" event and an "OnEnter" event and neither worked.

[Micron]

Maybe I'm stating the obvious, but the search text box has to be unbound. Consider also a combo instead - eliminates incorrect search criteria plus you don't have to know the number off by heart. Maybe users would like cascading combos, where they pick pertinent values to narrow the initial results, like filtering to find their own entries?