Query Lookups

[GregSmith]

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??

 

[Jack Cowley]

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]

 

[GregSmith]

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...

 

[GregSmith]

That did it!!

I figured out what I was doing...

Thanks for the help!!