Unable to modify bound fields in datasheet view

  • Thread starter Thread starter tsluu
  • Start date Start date
T

tsluu

i've assigned form.recordsource to retrieve data from several tables in sql
query. i was unable to edit any bound fields in datasheet view. it appeared
locked. however, when I run the same sql query in query design view, I can.
Any idea why?

any help would be appreciated.
 
tsluu said:
i've assigned form.recordsource to retrieve data from several tables in
sql
query. i was unable to edit any bound fields in datasheet view. it
appeared
locked. however, when I run the same sql query in query design view, I
can.
Any idea why?

any help would be appreciated.
Click to expand...

Make sure the form's AllowEdits property is set to 'No'.
 
i think Stuart meant to make sure the form's AllowEdits property is set to
Yes. also check the RecordsetType, and make sure it is *not* set to
Snapshot. and check to see if there is any code running in the form's Open,
Load or Current events that would disallow edits. and if you're opening the
form using code, make sure the calling code is not opening the form as
ReadOnly.

hth
 
Back
Top