Main Page | Report this Page
Computers Forum Index  »  Computer - Databases - MS Access  »  Add record to main form table but not Subform table...
Page 1 of 1    

Add record to main form table but not Subform table...

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
 
 
Page 1 of 1    
All times are GMT
The time now is Sat Dec 05, 2009 6:49 am