Hello All,

I am trying to update bound text box values so as to update the record in 
the table. I have a form that i set the data entry to "NO" b/c the 
recordsource of the textbox controls are bound to the value from the database 
using a  query.

Once the form pulls up the record from the database i want the user to be 
able to edit the current values of the texbox control to allow them change / 
update any value from what it was originally and i can update the records in 
the table

My problem:
I am not able to edit the individual textbox values because they are bound 
how do i make it so that they can be edited even though they are bound? When 
i change the form data entry to yes, the texbox(s) are no longer populated / 
filled out.

Thanks.

Ecwhite -

The 'data entry' property indicates entry for a new record, which is why 
they are blank when you turn that on.  You can keep that as No for updates.  
To update the table, the controls must be bound to the record.  Can you 
explain what you mean by you are "not able to edit the individual textbox 
values"?  Are they grayed out or something?  Are all controls disabled, or 
just some?  

Your form should have "Allow Edits" property set to Yes.  Your individual 
controls should have "Enabled" set to Yes, and "Locked" set to No.  I don't 
suspect the recordsource if you were able to enter data in the "Data Entry" 
mode.

Give us a little more information on the form and its controls and describe 
what happens when you try to update.

-- 
Daryl S


"ecwhite" wrote:

> Hello All,
> 
> I am trying to update bound text box values so as to update the record in 
> the table. I have a form that i set the data entry to "NO" b/c the 
> recordsource of the textbox controls are bound to the value from the database 
> using a  query.
> 
> Once the form pulls up the record from the database i want the user to be 
> able to edit the current values of the texbox control to allow them change / 
> update any value from what it was originally and i can update the records in 
> the table
> 
> My problem:
> I am not able to edit the individual textbox values because they are bound 
> how do i make it so that they can be edited even though they are bound? When 
> i change the form data entry to yes, the texbox(s) are no longer populated / 
> filled out.
> 
> Thanks.

Thanks Daryl. All settings are exactly what you described. 

What I mean is i can not type into the textbox. When i try to type so as to 
change what is currently showing in the textbox  i hear the ding sound i 
can't type. I have not even started the update i just need to be able to 
overwrite the current value in the textbox by adding to or typing over.

"Daryl S" wrote:

> Ecwhite -
> 
> The 'data entry' property indicates entry for a new record, which is why 
> they are blank when you turn that on.  You can keep that as No for updates.  
> To update the table, the controls must be bound to the record.  Can you 
> explain what you mean by you are "not able to edit the individual textbox 
> values"?  Are they grayed out or something?  Are all controls disabled, or 
> just some?  
> 
> Your form should have "Allow Edits" property set to Yes.  Your individual 
> controls should have "Enabled" set to Yes, and "Locked" set to No.  I don't 
> suspect the recordsource if you were able to enter data in the "Data Entry" 
> mode.
> 
> Give us a little more information on the form and its controls and describe 
> what happens when you try to update.
> 
> -- 
> Daryl S
> 
> 
> "ecwhite" wrote:
> 
> > Hello All,
> > 
> > I am trying to update bound text box values so as to update the record in 
> > the table. I have a form that i set the data entry to "NO" b/c the 
> > recordsource of the textbox controls are bound to the value from the database 
> > using a  query.
> > 
> > Once the form pulls up the record from the database i want the user to be 
> > able to edit the current values of the texbox control to allow them change / 
> > update any value from what it was originally and i can update the records in 
> > the table
> > 
> > My problem:
> > I am not able to edit the individual textbox values because they are bound 
> > how do i make it so that they can be edited even though they are bound? When 
> > i change the form data entry to yes, the texbox(s) are no longer populated / 
> > filled out.
> > 
> > Thanks.

The reasons that a bound form will not allow records to be edited include:

1) AllowEdits for the form is set to No
2) The underlying query the form is based on is Read-Only
3) User doesn't have Write Permission for the folder where the data resides.
4) Form's Recordset Type is set to Snapshot

To see if #2 is the case, from the Objects Dialog box go to Queries and click
on the query that your form is based on to open it. Now try to edit a record
directly in the query. If you're unable to do so, this is the cause of your
problem.

If your query is Read-Only, follow this link to Allen Browne’s article
explaining the reasons this happens.

http://allenbrowne.com/ser-61.html

-- 
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

Thanks a lot to you and Daryl. No. 2 was my problem. I had the GROUP BY 
clause in the query which made is read only.

"Linq Adams via AccessMonster.com" wrote:

> The reasons that a bound form will not allow records to be edited include:
> 
> 1) AllowEdits for the form is set to No
> 2) The underlying query the form is based on is Read-Only
> 3) User doesn't have Write Permission for the folder where the data resides.
> 4) Form's Recordset Type is set to Snapshot
> 
> To see if #2 is the case, from the Objects Dialog box go to Queries and click
> on the query that your form is based on to open it. Now try to edit a record
> directly in the query. If you're unable to do so, this is the cause of your
> problem.
> 
> If your query is Read-Only, follow this link to Allen Browne’s article
> explaining the reasons this happens.
> 
> http://allenbrowne.com/ser-61.html
> 
> -- 
> There's ALWAYS more than one way to skin a cat!
> 
> Answers/posts based on Access 2000/2003
> 
> Message posted via http://www.accessmonster.com
> 
> .
>