A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Text Field is Now Combo Box



 
 
Thread Tools Display Modes
  #1  
Old February 1st, 2010, 09:55 PM posted to microsoft.public.access.tablesdbdesign
PlarfySoober
external usenet poster
 
Posts: 68
Default Text Field is Now Combo Box

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.
  #2  
Old February 2nd, 2010, 01:04 AM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default Text Field is Now 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.

--
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.


  #3  
Old February 2nd, 2010, 02:57 AM posted to microsoft.public.access.tablesdbdesign
PlarfySoober
external usenet poster
 
Posts: 68
Default 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.


.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.