access query pop up

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access query pop up box

Access query pop up box

resolvedResolved · Low Priority · Version Standard

Emma has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Access query pop up box

Hi there,

I was wondering if it was possible to have an input pop up box come up when running a query that instead of input you had a drop down box with fields from another table?

Edited on Thu 27 Mar 2008, 11:25

RE: Access query pop up box

Hi Emma, Thank you for your post, in answer to your question, if your query is based on a table which has a field created as a lookup up field, the field can be used in your query and the lookup will work just as it does in the table.
If you wish to have this operate in the way that a peramater query works, ie bringing up an input box for user intervention, I dont think that will be possible.
I hope that answers your question, best regards Pete.


 

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips


Server loaded in 0.09 secs.