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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|