update query to include subform/child table

[Jin]

I add data to some fields in a form which includes subform (one field and one to many instances).

When finished I want to click button to update other records meeting criteria with the same data that has been entered. But this will include the subform data (held in one to many table).

Can i do this with any update query or do I need to do VBA with loops and stuff ?

thanks so much if anyone can answer this. I haven't used Access in long time

[orange]

If you are updating several tables from data in a subform, my guess is you will need some vba.
Can you give some sample m data and table info to show us details of what you want to happen?

[Jin]

Hi, thanks for answering my query. Here is some more info.
Please see attached jpg (I had to black out some sensitive
stuff) - it's the single form i use for the database.

So, all the fields except the CS categories are in one table,
lets call it maintable

CS categories table is related to maintable in one-to-many.
The database is already complete, there are no new records to
be added (except to the cs categories which is sub table of
main)

A user searches by SN number and it filters, for example, 5
records.

The user updates ONE of these with records, a few fields. One
of the fields updated is CS categories - adding several
choices from a list box which is a lookup from another table

I then want the option of pushing a button to update the
other FILTERED records with the changes.
Which means somehow copying all the added CS categories to
the other records.
I hope this makes sense.
thanks