Hi all,

I have a combobox on my form. The combo is currently populated by values from a table in a DB. I have two questions:-
1- Suppose I need to select more than 2 items in the dropdown, how can I ascertain the selected items?

2 - I want my users to check in the combobox dropdown if what they are looking for is already available in the DB if NOT available, then I want to allow them to type/key in the missing item directly in the combobox is this possible?

If the answer is yes, please let me have a sample code of how I can code that.

Thanks

1. In a loop, run through each item and test whether its .Selected property is True. (There are samples of this in Help.)

2. Are you using VB 6, the VBA that is contained in Access, or . . . ?
    If you are not using the VBA behind Access, what is your data kept in?

Am using VB6 (forms & coding) and the database is stored in MsAccess 2003.

The Access controls are really helpful here. But you're using VB, so that's no help.

I just now made a simple form with a combo on it, and it allowed me to type randomly into it.
So then, on Lost Focus, Change, or maybe Validate, I suspect that you can search to see if the data typed in matches anything existing, and take appropriate action if not. (Add it to the database then requery, or whatever.) I'm afraid I'd need to do some experimentation to be more explicit.

Sure seems like a behavior that Microsoft could have anticipated a little better...

Hi Brian,

Any idea how that can be coded?

Will really appreciate your help.

Thanks