update table field from unbound form control

[Patrick]

Access 2002

If you have a control source in a form is it possible to update a table
field with that control source? I have a text box in a form that has a
formula in the control source returning a value and I want a field in the
table to be updated by this function return. I have different tables that
have different information about the companies process and need to tie them
all together with this value. The value is created when you enter data into
the form.

 

[Alex Dybenko]

Hi,
you can use for example textbox afterupdate event, or some button click
event, to run UPDATE query. just make one which updates other table with
entered value and run it using:
currentdb.execute "myquery", dbfailonerror

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com