Editing data in a bound form

G

Guest

Please excuse my ignorance, but why can't I edit data in my bound and
filtered form?
 
O

OfficeDev18 via AccessMonster.com

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
 
B

Brian Bastl

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
 
G

Guest

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top