Checkbox to Populate Linked Table with Redundant Data

[rawlstonb]

I'm working on essentially an external add-on to an existing database. I've got many fields on a form that populate the local database's 'tblRouterData' table. The 'Submit' button populates all the fields in that table and sends an e-mail for notification of task completion, but I need a check box on that form that will initialize a select few of those fields to also populate in the linked database's Main table as an optional secondary Control Source...



Secondary Populate Fields for Linked Table 'Main':

txtAuthor -> Main.Work Order Prep Person
(name)
txtStartDate -> Main.Work Order Start
(date)
txtFinishDate -> Main. Work Order Finish
(date)
chkLineItemComplete -> Main.Work Order Complete
(checkbox)

The tables are linked through tblRouterData.SO# -> Main.Sales Document

If any more information is needed I'll be happy to provide it. So note, I'm novice-level at best... especially with code I don't understand, so notes as to why code is needed where are super-helpful to me.

Thanks!

[ranman256]

the button click can run a separate query before /after the main query

if chkBox.value then docmd.OpenQuery "quUpdateFlds1"
docmd.OpenQuery "quUpdateFlds2"

[rawlstonb]

the button click can run a separate query before /after the main query

if chkBox.value then docmd.OpenQuery "quUpdateFlds1"
docmd.OpenQuery "quUpdateFlds2"

That sounds wonderful... and probably exactly what I need to do!

So, where do I put that and what queries do I need to create?

Yes, I'm serious unfortunately lol

[ranman256]

in the button click event

sub btnRun_click()
if chkBox.value then docmd.OpenQuery "quUpdateFlds1"
docmd.OpenQuery "quUpdateFlds2
end sub

[rawlstonb]

I don't want to have to backtrack too far and pull the e-mail code and get super-confused again... is this going to work?

I used the query wizard to set up "qryUpdateMain" which pulls the things that need updating from table main but I don't see how they're going to connect to the fields that are updating them as is... all it does is open the query



Edit: OK I set the Value = -1 and the query opens on check and doesn't on not checked, so this should theoretically work... I just need to know how to set up the query itself to update the Main table in the correct places with the correct values

Edit Again: Looked up update query and I think I got this... thanks