Text Field is Now Combo Box

  • Thread starter Thread starter PlarfySoober
  • Start date Start date
P

PlarfySoober

I have an input form in which the user can select a job title from a combo
box list to be applied to a field in the query the form is based on. The
query uses data from the Candidate table and the Job Title table.

The combo box gets its choices from the JobTitle table, to be applied to the
Job Title field in the Candidate table. The JobTitle table is a list of job
titles and a couple of other columns not relevant to the form.

But now, I see that the text field in the Candidate table is somehow also a
combo box. And it doesn't work. It oddly has some of the same problems I had
to solve with the form, previously, with help from this forum: selections
don't get applied to the field and more than one column of the combo box (in
the form it's used to select from a list of job titles stored in a separate
table).

Does the fact that I used a combo box in the input form mean that the field
in Candidate table, that I thought would just have vanilla data (it's a Text
field), now has to be a combo box?

If that is true, I have made a mistake with this I need to rectify, as I
can't have the data in the Job Title field in Candidate table modifiable like
that.

Oddly, again, I note that the records that were ALREADY filled in from the
Combo Box in the form, are stable and don't seem to be going anywhere. Just
ones that were blank dis;lay as changeable combo boxes. And, notable, a
report I am preparing also shows the Job Title field as a combo box.
 
1. Open the table in design view.

2. Select the problem field.

3. In the lower pane, on the Lookup tab, set the Display Control property to
Text Box.
 
Back
Top