| Computers Forum Index » Computer - Databases - MS Access » Add record to main form table but not Subform table... |
|
Page 1 of 1 |
|
| Author |
Message |
| paul... |
Posted: Thu Nov 05, 2009 5:20 pm |
|
|
|
Guest
|
Hi
I have a form/subform set up, with a button to add a new record. I
want the button to add the new record to the main form but not add any
data to the subform.
However, using docmd.gotorec etc appears to do what i want, clearing
the data in the mainform and leaving the related data in the subform,
but when i look at the table bound to the subform it has added a new
record into the table.
Any ideas how i can prevent this happening?
Thanks
Paul |
|
|
| Back to top |
|
|
|
|