update table using text box in the form

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

I created an unbound text box in a form. The data I enter manually and I want
this data to be saved in a certain field name in the table.

Table Name - PolicyInformationSheet
Field Name - ProjectName

Form Name - Customer
Textbox - Text box 1
 
are you wanting to *update* a record in the table? to do that, you need a
way to identify what record(s) need to be updated - unless the table will
never hold more than one record. then you can use an Update query to update
the table record(s).

or are you wanting to *add* a record in the table? you can write an Append
query to do that.

in either case, you can call the query from some event in the form, such as
the textbox control's AfterUpdate event, for instance. suggest you read up
on Append queries and/or Update queries, in Access Help, and post back with
more specific information, if you have further questions.

hth
 
Tina,

all the fields in the form appends the table, the text box should also
append the corresonding field in the table just like a combo box.
 
if "all the fields in the form appends the table", there must be something
different about the text box, or you wouldn't be having a problem with it.
what's different?

hth
 
Back
Top