Unable to modify bound fields in datasheet view

[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.

 

[Stuart McCall]

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.

Make sure the form's AllowEdits property is set to 'No'.

 

[tina]

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

 

[Stuart McCall]

Thanks for the catch, Tina.

 

[tina]

de nada