By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,838 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,838 IT Pros & Developers. It's quick & easy.

Access 97 automatically creating drop down lists

P: n/a
Im very new to Access 97 and Im sure I should be able to do this but
cant work out how.
Im bulding a database for my stamp collection. I have two tables; one
with details of all the individual stamps, and one with details of
covers/envelopes the stamps are fixed to. Each indivdual stamp has a
specific reference number (not an auto-number). Rather than manually
enter the reference number into my 'covers/envelopes' table I want
Access to give me a drop down list of the possible ref numbers to
choose from.
So if there are five different stamps which have been issued with a
value of 1.20, and the cover Im cataloguing has a 1.20 stamp on it,
I can select the ref number from an automatically generated drop down
list that doesnt have all 250 stamps of all values on it - just the
two or three 1.20 ones.
Any suggestions would be welcome.
Thanks
Phil
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 4 May 2004 15:03:40 -0700, ph************@ntlworld.com (Phil
Longworth) wrote:
So if there are five different stamps which have been issued with a
value of 1.20, and the cover Im cataloguing has a 1.20 stamp on it,
I can select the ref number from an automatically generated drop down
list that doesnt have all 250 stamps of all values on it - just the
two or three 1.20 ones.


Use a Query, with the Distinct option, set the properties of your
drop down to the Query... you will see only the unique entries
John Thomas Smith
http://www.direct2usales.com
http://www.pacifier.com/~jtsmith
Nov 12 '05 #2

P: n/a
Hi Phil,

My suggestion would be to create a query from the table that contains
the value (Reference Number) you want in the Combo Box. The query may
contain only the one column, or can contain additional columns, as you
desire.

Once you have the query defined, click the 'Groups and Totals' button
(looks like a wierd shaped E [called a Sigma]), the default behavior
will be to Group the Columns by each distinct value found. You can
then save the query.

Use the Combo Box wizard to insert a new Combo Box on the form, and
follow the questions asked by the Wizard. When it asks about the
Table/Query to be used, select Query and then select the Query you
just created.

When you run your form, you will have a new Combo (Drop Down) box,
with each unique Reference Number listed.

HTH,

Marlin Snyder

ph************@ntlworld.com (Phil Longworth) wrote in message news:<60**************************@posting.google. com>...
Im very new to Access 97 and Im sure I should be able to do this but
cant work out how.
Im bulding a database for my stamp collection. I have two tables; one
with details of all the individual stamps, and one with details of
covers/envelopes the stamps are fixed to. Each indivdual stamp has a
specific reference number (not an auto-number). Rather than manually
enter the reference number into my 'covers/envelopes' table I want
Access to give me a drop down list of the possible ref numbers to
choose from.
So if there are five different stamps which have been issued with a
value of 1.20, and the cover Im cataloguing has a 1.20 stamp on it,
I can select the ref number from an automatically generated drop down
list that doesnt have all 250 stamps of all values on it - just the
two or three 1.20 ones.
Any suggestions would be welcome.
Thanks
Phil

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.