Is your form's data recordsource defined as the table (or query)? If it's a query, is it an updatable query? If not, we need to modify the underlying data of the form. Maybe look at it from a different angle...
Next viewpoint is, how is your form set with the following properties?
Allow Filters
Allow Edits
Allow Deltions
Allow Additions
Data Entry
Believe it or not, those can be very powerful settings, but they're a pain the u-no-what when it comes to debugging forms.
I look forward to helping you, Roy McCafferty
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)
"I do this because I know I can - no need to send gifts - just send me a smile to show me that I've helped." ~ seen on a cardboard sign held by Roy McCafferty on a corner in Las Vegas
For the Add Button:
OnClick do this EventProcedure:
DoCmd.GoToRecord , , acNewRec
For the Delete Button:
OnClick do this EventProcedure:
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
This is the exact same coding as if I had used the Button Wizard.
HTH! Roy McCafferty
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)
"I do this because I know I can - no need to send gifts - just send me a smile to show me that I've helped." ~ seen on a cardboard sign held by Roy McCafferty on a corner in Las Vegas
I just checked the EventProcedure's for both buttons, and the codes were already there. I think this isn't working, because I'm trying to add/delete through a subform/subreport that I added to my form. I'm not sure how to get these button to work with my subform/subreport. Any assistance would be wonderful.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.