Allowing Edits in Form

S

suzmb

I have created a form for editing current database info.
The form opens, but does not allow edits. I open it with
a macro in which i have specified to allow edits, and I
also checked the form properties and it is also specified
to allow edits. am i missing something????
 
A

Art

Hi Suz,
What is supplying data to your form? If it is a
query, check to see if you can add a record to the query?
Is the New Record button on the navigation bar bolded or
greyed out? If is a table, enter a new record. If you get
an error, post back and let us know.

Hope This Helps
 
S

suzmb

A query is supplying the data to the form. I have a field
that requires the user to enter the job # they wish to
edit. The query runs correctly and also allows me to add
a record to it
 
A

Art

Make sure the form is set for Allow Additions and Allow
Deletions = YES. Can you open the form without the macro?
If so, can you then edit data?

Hope This Helps
 
S

suzmb

i cant open the form without the macro unless of course it
is in design mode. and both allow additions and allow
deletions are set to yes. i swear this form worked
before, but i can't think of what i could have changed
that made it not work now.
 
A

Art

If you take the macro out of the form and click on form
view..what happens? What kind of error message do you get?
 

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

Top