Updating a field on a continous form

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.

On Mon, 5 Jul 2004 01:25:05 -0700, "David Batt"
wrote:

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


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


----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---