ComboBox Duplicates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DontellTrevell - 21 Feb 2007 21:29 GMT

Help Help!!

I have a combo box named cboALPHA with 5 records. The 5 "unique" records are:
AAA; BBB; CCC; DDD; EEE.

I want the user to get a MsgBox when any of the 5 records are chosen. The
cboALPHA needs to look into a table where the 5 unique records are stored.
The table name of the 5 records is: tblALPHA.

So, when the user chooses one of the unique five, MSGBOX should say; "this
record already selected.

Signature

Dontell Trevell

Reply to this Message

Damian S - 21 Feb 2007 22:12 GMT

If you put a msgbox in the after update event of your combo you will get a
message every time something is selected, but I'm not sure what you would
achieve by doing that. What are you trying to achieve here?

Damian.

> Help Help!!
>
[quoted text clipped - 7 lines]
> So, when the user chooses one of the unique five, MSGBOX should say; "this
> record already selected.

Reply to this Message

DontellTrevell - 21 Feb 2007 22:34 GMT

The main data table can not have duplicates. When I select an item from the
combo box that is already in the main data table, user needs message saying;
that is a duplicate record.

>If you put a msgbox in the after update event of your combo you will get a
>message every time something is selected, but I'm not sure what you would
[quoted text clipped - 7 lines]
>> So, when the user chooses one of the unique five, MSGBOX should say; "this
>> record already selected.

Signature

Dontell Trevell

Reply to this Message

DontellTrevell - 21 Feb 2007 22:58 GMT

Let me try to explain clearer: When user selects an item in the combo box
that is already selected and stored in a data table. (1) I want the item
ghosted or not visible in the combo box. or (2) Give user a msgbox that
says record has already been selected. Is that better?

>The main data table can not have duplicates. When I select an item from the
>combo box that is already in the main data table, user needs message saying;
[quoted text clipped - 5 lines]
>>> So, when the user chooses one of the unique five, MSGBOX should say; "this
>>> record already selected.

Signature

Dontell Trevell

Reply to this Message