param query=form w/ one record,need cmdbutton find another record

[keiserc]

I have a basic param query/form which displays a certain record (or recordset). How do I create a command button to requery a new record (or recordset). I don't want the user to have to close the form & start over to check a different record. I'm sure this is a basic thing. But I don't know where to start & I've searched all the posts I can think of.

 

[scriverb]

If you have a parameter query for the recordset of your form like the following:

Select A.* FROM [i]yourtablename[/i] WHERE A.[ID] = [Enter ID#: ];

Then just put this code behind a command button:

Me.Requery

This should do it as the requery of the form will trigger a requery of the recordset and a new promping for your ID#.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]