Form/SubForm Edit Mode

K

Kirk P.

I have a form (frmCustomers) and a subform (sfrmRevenue). When the form
opens, I have code that moves the focus to sfrmRevenue and allows only new
records to be added. I have a command button called Edit Details on the
Customer form. When clicked, I would like the user to be able to edit any
records in the subform. The button doesn't work - it's not placing the
subform in Edit mode. Here's the code:

Me![sfrmRevenue].SetFocus
Me![sfrmRevenue].Form.AllowEdits = True

Is there something wrong with the code?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Go To New Record on Subform 3
After Update Event Issue 2
Subform Allow Edits Issues ? 5
Populate main form from subform record 0
can't lock a subform in subform current event 2
Dynamic Naming of Form Button 3
DLookup in Continuous form 0
Referring to control in the active subform 0

Top