Exclude From ComboBox

[ddrew]

How do I exclude something from a ComboBox please?

My form is a profile of a dog and contains a Dog_ID. The ComboBox is a list of dogs names and shows all the females I want it to show all the females less the female that it is being linked with.

 

[CJ_London]

you'll need to populate the combobox rowsource using vba in the form current event. You haven't provided details of your current rowsource or table names/structures, so I'm using 'air' code which you will need to change to suit.

Sub Form_Current()

ComboboxName.RowSource="SELECT NameID, DogName FROM TblDogNames WHERE NameID<>" & Me.NameID & " AND DogType <>'bitch'"