Combo box to disallow first choice

[jjdoro]

Is there a way to make a combo box disallow the first choice. I can do this in combo boxes using Front Page but I do not know how to do this with Access. The combo box I have is a list of names of people who will be conducting interviews but the combo box will show (Interviewer) when it opens. To make sure they don't forget to address that field I want to disallow it as a choice. Thanks

 

[fneily]

Does your combobox have a Default value? Normally, comboboxes open up blank unless it's coded or someone placed a default value on the property sheet. Maybe you could be a bit more clearer.

Neil

 

[jjdoro]

Fneily, yes the combo box does have a default value however when I enter what I want to show as default
it is replaced by #Name?. The combo box is in a subform which has a list of interviewers that is drawn from a table (actually the combo box builds a query to that table). If that field is empty instead of it being blank i would like it to show (select interviewer here).

 

[fneily]

This is my translation of what you're saying. You have a combobox and you're trying to put in a default value that says "select interviewer here" and you're getting #Name. In your table with the list of interviewers, make the First record have the field interviewer say (select interviewer here). So this is like an interviewer with three names.
Then for your default value of the combobox, on the property sheet, type:

[comboboxname].[ItemData](0)

This says to show the first interviewer in the list which would be (select interviewer here).