I created a form with an unbound text field, txtRefNum. This form is bound to a query whose criteria for RefNum is txtRefNum. I didn’t put anything in the afterUpdate event of txtRefNum. However, after updating txtRefNum, all the other fields remain blank, nothing happens, no change. Help? I’m trying to goto a single record with this approach.

I would set-up the query to remove the criteria and base your form on that.

Then do the following:

1) Create a query that pulls all of the txtRefNums named "qryRefNums"

2) Create an unbound combo box named "customerselect"

3)Create a macro named "FindRecord"

4) In the first Action cell type "GoToControl"

5) Type "Name of Text Ref Field on form" in the Control Name argument cell

6) Type "FindRecord" in the next action cell

7) Type "=[CustomerSelect]" in teh Find What argument box

8) Save the macro

9) Open up the properties of the Unbound Combo Box that you created -- Make sure that it is named "customerselect". Then make sure the Row Source is set to "qryRefNums"

10) In the AfterUpdate property of the Combo Box, type "FindRecord" (this is the name of the macro you created)

I have used this way of creating a search for several times, it comes from the "Access 97 Bible" by Prage and Irwin. If you are a beginning-intermediate developer, you should get this book. It helped me to learn a lot and move forward into more complex programming.

Let me know if you need any other help.

Doug

Thanks Doug I will try that out, I’ve sort of happened upon a temporary fix of kinds a simple parameter query got the job done. Problem is that I need to call the parameter box again once I’m done & want to go to some other record but I don’t know how to do that.