Won't open to new record in form

R

Renee

I have used the following code in my form and it keeps telling me that it is
not available at this time:

If Not Me.NewRecord Then
RunCommand acCmdRecordsGoToNew
End If

I have all my allow additions, allow deletions, allow edits, allow filters
set to yes and it still won't let me. Is there something I am missing?
 
G

Golfinray

Make sure your table and query are editable. If they are they will have the
arrow and asterisk at the bottom. If your table or query are not editable,
your form won't be either.
 

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

Open to Blank Form 5
Open read-only form blank 2
blank form, can't insert new record 11
Space at end of multi page list to accommodate new entries 1
Unclear change tracking process 0
Excel suddenly crippled by Just-In-Time Debugging 2
Can't edit subform - main form should not be edited. 2
Open Form to New Record 3

Top