update data from subform (datahseet view)

[yschuerm]

I have got a form that consists off a subform and some buttons.
The subform contains the datasheet of a searchquery of a table.
I would like to be able to edit the row in the subform and update the change to the corresponding table.

Competitor Competitor ArtNr Competitor Art Description Source Customer NR Date Price Price Unit Country (BE/NL/LU/UK) Customer Language NL/FR/UK BernerArtNr Data Data Nr Text Bla 210000456 05.06.15 10 100 NL NL Data Data Nr Text abc 210000456 05.06.15 10 100 UK UK <caption> ResultMissingForm </caption> <thead> </thead> <tbody> </tbody> <tfoot></tfoot>

<tbody>
</tbody>

I would like to update BernerArtNr and when i click the save button on the mainform (or different way if needed), this will be updated in the source Table (competitors).

 

[yschuerm]

allready solved by using a simple query.

I am used to vba for excel and fairly new to access. Really need to remind myself to the use of queries instead of trying to invent the wheel.