I Need bound text box assistance

B

Brent E

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

Dirk Goldgar

Brent E said:
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.
Click to expand...

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