Drop down box

[chgobears03]

Hi,

I am fairly new to Microsoft Access and I just opened my own business. I am creating a database for all my customers and in it I would like to add a field that contains the payment of method. I then want to be able to click on the right of the field to get a drop down menu with the choices of cash, check, & credit card.

I know there is a way to do this and I just can't figure it out. Any help would be fantastic.

Thanks,

Justine

 

[Dreamboat]

Hi, Justine.

This is how I would do it, tho some might argue not to use lookups in a table; but I think it's fine for your purposes.

Create another table called tblPmtMethods, with these fields:

ID (autonumber)
PmtMeth (text, prolly 10 or 15 characters)

Enter some payment methods into the table.
Go to your records table, and put a new field in, type: lookup. Let the wizard take you through grabbing the payment method from that table and hide the ID column.

If you're just now creating your DB and want to stay out of trouble, I'd be willing to review it for you. I'm no coder or anything, but I'm good with tables and the rules you'll need to follow to stay out of trouble.

Anne@vbaexpress.com

 

[Mile-O]

Create another table called tblPmtMethods, with these fields:

ID (autonumber)
PmtMeth (text, prolly 10 or 15 characters)

PmtMethID (autonumber - primary key)
PmtMeth

I see a lot of people leave their primary key field called ID which isn't advised as then you end up with so many fields called ID within the database. Name the ID field after the topic of the table and append ID to its name.

Also, you describe this as if you are just entering data directly into a table which isn't advised. Or are you actually using forms?

 

[Dreamboat]

Mile-O

Quite right.
Sorry 'bout that!