I have a form and a command button to display a query called "tape entry".

What I want is a vb code that I can insert into the event procedure that will prompt you for a begin ID and a end ID. I do not want to insert the serach in the query from the query field (criteria)

Any ideas??

Add two unbound fields to your form called BeginningID and EndingID. In your queries ID criteria field put code like this:

Between [Forms]![YourFormName]![BeginningID] And [Forms]![YourFormName]![EndingID]

I am doing this but when I press the query button in my form, nothing but a blank query comes up. It's the correct query thou...

That did it!!

I figured out what I was doing...

Thanks for the help!!