@arnelgp
Indeed, that's the issue. I've been overlooking this for three day's.
After correcting the last line all works well
Thanks both off you for the time
@ Gasman
Sorry, Typo from me. In the code lijst_id should be replaced by lijst.kar_id. This happened in editing the code fragments for this Post.
for clarity:
with the DoCmd.goToRecord as illustration
I have troubles deleting records using the DoCmnd.RunSQL function.
Part of the application consist out of a form with a subform based on a 'parent' table called "kar" and a 'child' table called "lijst". The tables have a one to many relation.
The parent form contains a command button that...
Hello,
Busy in a chemical research lab, dealing with all kind of instrumentation (software/electronics/...) issues.
I have been writing msaccess/vba applications on a regular base the last 25 years