I am creating a form that needs to use drop-down lists or combo boxes (never figured out what the real difference was).

I need to be able to select and store multiple values for reporting purposes.

Any help would be appreciated.

Thanks.

They are two names for the same thing. Forms have combo boxes, data access pages have dropdown lists. But the functionality is basically the same.

For multiple values, I generally use a multi-select list box. I have attached an example of how I do it.

Thanks Frank. Unfortunately, I don't see your example. I did change my box to a list box, and changed the properties to extended. However, when I click a new record in the form, the same items highlighted in the previous record are still highlighted, and when I looked at my table, only one value was saved.

I appreciate your help.

Susie

Yes, Susie, you'll need to modify my example to suit your needs.

Frank - I'm new to this site as of today. So, I have no idea where your sample is??? Is it hidden in a link somewhere?

Thanks,
Susie

No, it's on one of the forms in the database. frmListCriteria is the name of it.

Edited by: fkegley on Thu Oct 6 14:09:27 EDT 2005.

What database and where is it located?

It's in the attachment that I sent you in the original response. At least it is showing up there on my computer. Perhaps your web server is stripping out attachments? I'll attach it to this post. Look for the word Attachments.

Thanks Frank. My company blocked the attachment that you sent and is denying me access to the attachment you have posted. I don't know what else to do??

I appreciate your help and patience.

Susie

Do you have another Email address? One that you can get to from some other computer?