February 2nd, 2010, 01:57 AM
posted to microsoft.public.access.tablesdbdesign
|
|
|
Text Field is Now Combo Box
Allen,
Well. That managed THAT. Thank you very much.
Don.
"Allen Browne" wrote:
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.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"PlarfySoober" wrote in message
...
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.
.
|