Interactive Query

[howlettb]

Hi. I've created a "clean up query" where I can put in specific information which I then want to edit (right there and then). I got everything to do what I want, except that the query results pop up behind the form asking for them. I know how to make a form/report a "pop up" ... can I do that to query results as well? When I close out of my query, it takes me out of the database entirely. Does anyone know how to make query results appear on top of a form, and how to make it so when you close the query results, you're back to the form? I'd appreciate any help you could give me. Thanks

 

[howlettb]

OK ... so I've figured out part of my problem. The forms leading up to the query are set as pop ups. If I take the pop up option off - then the query results do open on top of the form. However, when I take the pop up option off the form, it spreads my form out to the whole page - when it's set to just take up a section in the center. I can't figure out what I'm doing wrong. Can anyone help?

 

[vbaInet]

* Base your query on a form
* Set the form's pop-up property to Yes
* Open the form in Datasheet View

That's equivalent to opening a query because it looks and feels like it.

 

[howlettb]

Got it! Thank you so much!

 

[vbaInet]

No problem!

 

[howlettb]

Ok ... so I have another problem. I'm still working on trying to print checks from a database that I've created. Thanks to vbaInet, I was able to make $1 = one dollar (thank you very much). My problem now is trying to assign check numbers by typing in the 1st one. I've set up a form that pulls all the information that will go on the checks, and in the header, I made an unbound field to enter the first check number. How do I make the list update with consecutive check numbers using the one I enter as the first? As always, your help is GREATLY appreciated!