Updating a field on a continous form

  • Thread starter Thread starter David Batt
  • Start date Start date
D

David Batt

Hello,
I have a problem whereby I have a continuous form
which is bound to a read only recordset, however I wish
for one field on the form to be updatable, called say
unboundfield. If I set this field Unboundfield =
me.otherfield then it takes the same value for all
records on the form, If I use conditional formatting then
it becomes unusable.

Any ideas how I can overcome this problem.

Regards

David Batt
 
Continuous forms are very confusing! As far as Access is concerned,
the multiple copies of the form that you see are really multiple
"reflections" of a _single_ form. Although the diplayed recordset data
changes from "form" to "form", nothing else can/does. In particular,
you will only see what amounts to multiple copies of a single
calculated or otherwise unbound field. I am not sure that I understand
what you are really trying to do - if the recordset to which your Form
is bound is readonly, you are presumably trying to update a field in
another recordset, related to it in some way. You are likely to be
better off using an updatable recordset and modifying the form so that
the user can only change data in the field that you want to be
updatable.

Hello,
I have a problem whereby I have a continuous form
which is bound to a read only recordset, however I wish
for one field on the form to be updatable, called say
unboundfield. If I set this field Unboundfield =
me.otherfield then it takes the same value for all
records on the form, If I use conditional formatting then
it becomes unusable.

Any ideas how I can overcome this problem.

Regards

David Batt
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top