468,301 Members | 1,416 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,301 developers. It's quick & easy.

copy from subform a to subform b

hi, i have 2 subforms on a form(Form1) (SubformA and SubformB). each subform is on a seperate page of a tab control.

each of the subforms displays data in datasheet view. each of the subforms are based on their own seperate table(TableA and TableB). these 2 tables are linked to Table1, via a one to many relationship.

Each of the tables have similar Fields. I want SubformB to update automatically once i have entered in a new record to Subform A.

Please help
Oct 5 '06 #1
1 1309
PEB
1,418 Expert 1GB
So if I understand well, You need to copy the entred record in FormA to Table B?

Or it's a syncronisation between the 2 tables... Seenig the information about this record in Table A to Update the same record in tableB with the same value?

In this cases you need an event procedure in Your FormA

That with docmd.runsql "YOUR SQL" syncronize the data

The tip here is to know what event procedure to use

And what kind of query use.... Update query if there is syncronisation btwn records or Append query if there is add of new record...

Maybe both...

Best regards!
Oct 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Brooks Clayton | last post: by
3 posts views Thread by david | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.