Editing data with a form

  • Thread starter Thread starter l martin
  • Start date Start date
L

l martin

I have a form that selects fields from a table based on
criteria supplied by another form. They are displayed in
Datasheet view.

I want to be able to edit any or all of the data that is
retrieved, but when I move to a field, I am not able to
edit the data.

I have the Allow Edits, Allow Deletions, Allow Additions
properties of the form all set to YES.

Any ideas why I cannot edit the data?

Thanks.
 
Make sure that the Recordsource for your form is an updateable query. Open
the query in datasheet mode and see if you can edit records there.
 
You must log in or register to reply here.

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

blank form, can't insert new record 11
Edit a Form 6
Editing Data in Form 8
Editing in sub-form is locked 3
FORM-SUBFORM DATA ENTRY MODE PROBLEM!! 4
Form Values cannot be edited 1
Can't edit subform - main form should not be edited. 2
Access MS access forms list box problems 1

Back
Top