Combo Box list In Access

[fliu2265]

Hello Everyone,

I am new and hope you all are doing well.
I have a question regarding a Combo Box.
I created a Combo Box with lists as:
Math
Chemistry
English
History
How can I select item from the lists only once? For example , if I select 'Math', then next time If I select 'Math' again, I would
like to get a warning message such as 'You already select Math'.

Thanks

Frank

 

[Mike Krailo]

Maybe use checkboxes instead of combo box. Can you explain more of the big picture of what you are doing? The reason why I ask is that if this was for students to classes, usually there is many to many relationship and this changes everything. Also you did not say if the combo box is bound to a table or query or not.

 

[Uncle Gizmo]

I agree with Mike, more info required....

 

[theDBguy]

Hi. Welcome to AWF!

Is this combobox bound to a field in your table? If so, you might be able to use a unique index. Just a thought...

 

[Gasman]

You would have to record the fact that you selected it previously.

 

[Moosak]

Hello @fliu2265
I have done some thing similar before, Any item selected Before disappears from the list.
Check this :

The demo is attached below

 

[Moosak]

Okay Mr. Pat , lets use the same technique but in a sub form this time.
See what we got :

 

[arnelgp]

can you show that when the form is Datasheet or Continuous?

 

[Moosak]

can you show that when the form is Datasheet or Continuous?

It works in both ways.
This is the row source of the combo box :

SELECT DISTINCTROW ComboList_T.ComboList FROM ComboList_T LEFT JOIN Subjects_T ON ComboList_T.ComboList = Subjects_T.Subject WHERE (((ComboList_T.ComboList) Not In (select [Subjects_T].[Subject] from [Subjects_T] where [Subjects_T].[StudentID] = forms![DataForm]![ID] )));

 

[Mike Krailo]

That is something I have never seen before. Got any more tricks up your keyboard?