Editing data in a bound form

  • Thread starter Thread starter Guest
  • Start date Start date
It's not only the form that's bound, but the textbox as well. If your form
has a record source, and your textbox has a control source that is a valid
field in the form's record source, or even if the textbox's control source is
an Access function [e.g. "=Date()"], you have a bound textbox that cannot be
editted. This is because the textbox is forced to get its data from the
form's record source (or computer's date setting) so it's essentially
'locking out' the user from making any changes.

If you want to be able to make changes to the data, you must make the
textboxes unbound. To do this, you must remove the control source AND rename
the textbox (if necessary) so it is not equal exactly to any valid field in
the form's record source.

Hope this is helpful,

Sam
 
Is your form's recordsource a table or a query? If it's a query, is it based
on 1 table? If it's a multi-join query, then many times it will not be
updateable.

Brian
 
Thank you very much for your reply. Everyting you wrote makes sense, but
then how do I edit data in the underlying table? I know I've done this
before... If I make the textbox unbound its nolonger linked to the table...
I do want to be editing the table data.

Thank you again for your help.
Mark

OfficeDev18 via AccessMonster.com said:
It's not only the form that's bound, but the textbox as well. If your form
has a record source, and your textbox has a control source that is a valid
field in the form's record source, or even if the textbox's control source is
an Access function [e.g. "=Date()"], you have a bound textbox that cannot be
editted. This is because the textbox is forced to get its data from the
form's record source (or computer's date setting) so it's essentially
'locking out' the user from making any changes.

If you want to be able to make changes to the data, you must make the
textboxes unbound. To do this, you must remove the control source AND rename
the textbox (if necessary) so it is not equal exactly to any valid field in
the form's record source.

Hope this is helpful,

Sam
Please excuse my ignorance, but why can't I edit data in my bound and
filtered form?
Click to expand...
Click to expand...
 
It's a single table using a form filter.

Mark

Brian Bastl said:
Is your form's recordsource a table or a query? If it's a query, is it based
on 1 table? If it's a multi-join query, then many times it will not be
updateable.

Brian
Click to expand...
 
Back
Top