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

add combo boxes to form

100+
P: 107
Hello,
I have a store database already set up with alot of data in it.
I have one table: table1
fields: partNumber, storeName,date,amount,description- ( some others)
I have one form: form1
up to now users have entered data.

Now they want to be able to choice from a list of stores to enter storeName.
Now they want to be able to choice from a limited ( only applying to that store).
descriptions to enter description they want.
I thought I could use two combo boxes.
Is this possible.
I am unable to get anywhere with this.
Can you help?
Thank you
Dec 7 '07 #1
Share this Question
Share on Google+
3 Replies


puppydogbuddy
Expert 100+
P: 1,923
Hello,
I have a store database already set up with alot of data in it.
I have one table: table1
fields: partNumber, storeName,date,amount,description- ( some others)
I have one form: form1
up to now users have entered data.

Now they want to be able to choice from a list of stores to enter storeName.
Now they want to be able to choice from a limited ( only applying to that store).
descriptions to enter description they want.
I thought I could use two combo boxes.
Is this possible.
I am unable to get anywhere with this.
Can you help?
Thank you
You are correct about wanting two combo boxes. They allow you to provide what is known as Cascading Lists, in which the content of the second list is dependent on what is selected from the first list . As to how to use and implement, see this link for a great tutorial with a downloadble working database that corresponds to the examples used in the tutorial.

http://www.fontstuff.com/access/acctut10.htm
Dec 7 '07 #2

100+
P: 107
Thanks alot- this should put me in the right direction
Dec 8 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
Also, you give one of your fields as date. If this is, indeed its name, you need to change this before going any further!

Date is a Reserved Word in Access, and using these words will lead to problems sooner or later! Date is a particularly troublesome Reserved Word! Executing a statement such as

Date = Date + 30

for instance, won't add thirty days to the value of your field named Date, but rather will actually change your PC's system clock, setting the date it displays to thirty days in the future!

Linq ;0)>
Dec 8 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.