J
JP
Access 2002 / SQL Srv 2000 ADP
I have a subform, displayed in datasheet mode, based on a view.
The content of the view is restricted to rows matching status=1,
however I would like to allow the user to update the value of the
status column (a combo) via the form.
At present I am getting the following error:
"The data was added to the database but the data won't be displayed in
the form because it doesn't satisfy the criteria in the underlying
record source. "
I read numerous other posts and the KB articles regarding this error
and had reached the conclusion that what i want to do was impossible,
except for one thing: there is another form in the same database
which does exactly what i want (except it's restricted to rows where a
column is null).
I figure there must be some setting on this form which stops the row
being requeried when i update the combo, but if there is I cannot find
it.
Any help would be much appreciated. Thanks in advance.
I have a subform, displayed in datasheet mode, based on a view.
The content of the view is restricted to rows matching status=1,
however I would like to allow the user to update the value of the
status column (a combo) via the form.
At present I am getting the following error:
"The data was added to the database but the data won't be displayed in
the form because it doesn't satisfy the criteria in the underlying
record source. "
I read numerous other posts and the KB articles regarding this error
and had reached the conclusion that what i want to do was impossible,
except for one thing: there is another form in the same database
which does exactly what i want (except it's restricted to rows where a
column is null).
I figure there must be some setting on this form which stops the row
being requeried when i update the combo, but if there is I cannot find
it.
Any help would be much appreciated. Thanks in advance.