Access query pop up box

The UK's most regular instructor-led training courses.
Training information: microsoft access training class · Access training · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

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

by - delegate Emma [3 posts] (2008 Mar 18 Tue, 15:41) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Access query pop up box

by - trainer Pete platinum contributer [799 posts] (2008 Mar 27 Thu, 11:22) Edited on 2008 Mar 27 Thu, 11:25 Reply

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.

· How To Find Good Access Database Courses In London
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Why go on a Microsoft Access Training Course?
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Microsoft Access as a Business's Database Management System

Please browse our web site to find out more about
microsoft access training class and other Microsoft training courses.

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips