I Need Bound Text Box Assistance

[Guest]

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.

 

[Dan Artuso]

Hi,
The usual setup is that your form's record source is the table you want to save records to
or a query that includes more than one table. If you have a query, you must make sure that
the query itself is updateable. To test this, run the query itself from the query designer and you'll
see if it's updateable. If it's not, you won't be able to use your form to enter data.

If it is, then simply make the control source of your text box the field where you want to save the entry.