update table field from unbound form control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
Access Create option group without using wizard? 2
Access Control on subform / combo box requesting parameter 0
Open report from multivalue fields 1
Access Daily Entry with multiple entries per field 0
unbound OLE PDF Object in Access Report doesn't update 1
MonthView Calendar Control 7
VB updates in form field not updated in tables 1

Back
Top