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
|
|||
|
|||
unbound control
After placing a textbox (unbound control) on a form, what is the process to
bind it to a field from a table. I've tried adding the control source but keep getting #Name? Thank you -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200608/1 |
#2
|
|||
|
|||
unbound control
vbnetman via AccessMonster.com wrote:
After placing a textbox (unbound control) on a form, what is the process to bind it to a field from a table. I've tried adding the control source but keep getting #Name? Thank you That suggests that the field name you entered does not exist in the RecordSource of the form. Try this instead... In Form design view go to the toolbar and press the button that displays the Field List. Is the desired field in that list? If not, then your RecordSource needs to be modified so that it is. If the field is in the list just drag it to your form and Access will create a bound control for you. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
unbound control
Rick Brandt wrote:
After placing a textbox (unbound control) on a form, what is the process to bind it to a field from a table. I've tried adding the control source but keep getting #Name? Thank you That suggests that the field name you entered does not exist in the RecordSource of the form. Try this instead... In Form design view go to the toolbar and press the button that displays the Field List. Is the desired field in that list? If not, then your RecordSource needs to be modified so that it is. If the field is in the list just drag it to your form and Access will create a bound control for you. Hi Rick, Thank you for the response. No it is not in the field list. How can I modify the field list to include this? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200608/1 |
#4
|
|||
|
|||
unbound control
vbnetman wrote:
After placing a textbox (unbound control) on a form, what is the process to bind it to a field from a table. I've tried adding the [quoted text clipped - 10 lines] list just drag it to your form and Access will create a bound control for you. Hi Rick, Thank you for the response. No it is not in the field list. How can I modify the field list to include this? Rick, I see it. The keyword was recordsource of the form. I was looking at the conrol source of the control. Thank you -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|