Unlocking a bound control

[Pato-chan]

I've tried the Me.[Control Name].Locked = False as well as the Me.AllowEdits,
AllowAdditions and AllowDeletions = True in the Form_Open event but nothing
seems to be working. I have notes that I've associated with each unique
record but want the user to be able to update, edit and delete these notes.
My form is based on a query that's pulling data from two different tables.
What am I doing wrong?

 

[ruralguy via AccessMonster.com]

IThere is not really enough information to provide an accurate suggestion but
I'll guess your query is *not* updateable. Does your form just beep? Open
the query by itself and see if it will let you change anything. Key in
"Troubleshoot query" into the Access (not VBA) help wizard and look under
Select queries.

I've tried the Me.[Control Name].Locked = False as well as the Me.AllowEdits,
AllowAdditions and AllowDeletions = True in the Form_Open event but nothing
seems to be working. I have notes that I've associated with each unique
record but want the user to be able to update, edit and delete these notes.
My form is based on a query that's pulling data from two different tables.
What am I doing wrong?

 

[Pato-chan]

It is indeed a select query, not an update query. I need the user to be able
to see the selected records and then select which record he/she wants to
update the notes field for.

IThere is not really enough information to provide an accurate suggestion but
I'll guess your query is *not* updateable. Does your form just beep? Open
the query by itself and see if it will let you change anything. Key in
"Troubleshoot query" into the Access (not VBA) help wizard and look under
Select queries.

I've tried the Me.[Control Name].Locked = False as well as the Me.AllowEdits,
AllowAdditions and AllowDeletions = True in the Form_Open event but nothing
seems to be working. I have notes that I've associated with each unique
record but want the user to be able to update, edit and delete these notes.
My form is based on a query that's pulling data from two different tables.
What am I doing wrong?

 

[ruralguy via AccessMonster.com]

Is the query updateable?

It is indeed a select query, not an update query. I need the user to be able
to see the selected records and then select which record he/she wants to
update the notes field for.

IThere is not really enough information to provide an accurate suggestion but
I'll guess your query is *not* updateable. Does your form just beep? Open

[quoted text clipped - 8 lines]

 

[Pato-chan]

I'm not sure how I would base a form off an update query, if that's what you
mean. I can update the select query if that's what you mean.

Is the query updateable?

It is indeed a select query, not an update query. I need the user to be able
to see the selected records and then select which record he/she wants to
update the notes field for.

IThere is not really enough information to provide an accurate suggestion but
I'll guess your query is *not* updateable. Does your form just beep? Open

[quoted text clipped - 8 lines]

My form is based on a query that's pulling data from two different tables.
What am I doing wrong?

 

[ruralguy via AccessMonster.com]

Not an Update Query!! You can change data in a field in a select query
unless that query is *not* updateable.

As I said earlier:
Key in "Troubleshoot query" into the Access (not VBA) help wizard and look
under Select queries. You will find reasons why a Select query can not
update fields.

I'm not sure how I would base a form off an update query, if that's what you
mean. I can update the select query if that's what you mean.

Is the query updateable?

[quoted text clipped - 7 lines]