add combo boxes to form

[buddyr]

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,descript ion- ( 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

[puppydogbuddy]

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,descript ion- ( 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

[buddyr]

Thanks alot- this should put me in the right direction

[missinglinq]

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)>