ComboBox Duplicates

  • Thread starter Thread starter DontellTrevell via AccessMonster.com
  • Start date Start date
D

DontellTrevell via AccessMonster.com

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

Damian said:
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!!
Click to expand...
[quoted text clipped - 7 lines]
So, when the user chooses one of the unique five, MSGBOX should say; "this
record already selected.
Click to expand...
Click to expand...
 
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?
DontellTrevell said:
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
Click to expand...
[quoted text clipped - 7 lines]
Click to expand...
 
Back
Top