how can I update data to another table rather the underlying table

  • Thread starter Thread starter anj
  • Start date Start date
A

anj

Dear All
Thanks in advance!
I trying to save some control ( "size" and "height") data
from a "Form A" to another "Table B" that is not the
underlying table for the "Form A". For the moment I
using "Update Query" to update data from few control
on "Form A" to "Table B" but I want to do it by
code. "Form A" is base on table "Table A". How can I do it?
 
If you already have a query which does what you want, you can just run that
query using code:
DoCmd.OpenQuery "Put your query name here"

There are more complex ways to do this in code, but this might be the
simplest.
 
Back
Top