I Need bound text box assistance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brent E - 08 Mar 2005 22:07 GMT

Good afternoon,

I am trying to set up a bound text box, so that when a user types a value
into a text box on a form, that automatically adjusts that value in a
single-record table. I attempted to set control source of an unbound text box
to the table, but then I can't type anything in the text box, seems
unavailable. I also tried dragging a field onto form to create a text box,
but same problem occurs. What do I need to do so that the form serves as the
editable data entry point for the table record? Also is there a way to get
rid of the "?NAME#" message ina bound text box? Thanks.

Reply to this Message

Dirk Goldgar - 09 Mar 2005 00:13 GMT

> Good afternoon,
>
[quoted text clipped - 7 lines]
> table record? Also is there a way to get rid of the "?NAME#" message
> ina bound text box? Thanks.

Is the form's Record Source property set to the table that you want to
update? If it isn't, you can't bind the text box to the field. If it
is, binding the text box to the field should be very simple -- either
create the text box and then set its Control Source property to the name
of the field, or else drag the field from the field list onto the form.
If these methods aren't working, there's something very wrong with your
form.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message