Re: Updating a field on a continous form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: at (Peter)
Date: 07/05/04 

Date: Mon, 05 Jul 2004 15:30:19 +0100

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"
<anonymous@discussions.microsoft.com> 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 =---

Relevant Pages

  • Re: Using Recordset.State Property
    ... In this situation, you do not have multiple instances, there is only one ... If the recordset is being used for two or more distinct purposes, ... I do not have another declaration, ... >> Worked fine for me when I declared the rs as Public in a Standard Module ...
    (microsoft.public.access.formscoding)
  • Re: Datagrid multiple row selections
    ... > It is possible to press Ctrl and make multiple selections of separate rows ... ' First you'll need to make a clone of the recordset that's bound to the ... the bookmarks will not be ...
    (microsoft.public.vb.database.ado)
  • Re: Press one button to execute another one
    ... Window) consists of multiple sub- and subsub- forms based on quite elaborate ... queries and nested partly as tab controls, partly alone, and of groups of ... Initially I've tried to set the "transaction window" Entry property to Yes, ... subform's record source query to return an empty recordset. ...
    (microsoft.public.access.formscoding)
  • Re: DataSet.Clear required before loading new data?
    ... I am actually using the same dataset over & over for multiple uses. ... With an ADO recordset, once the recordset was closed then I could use it for ... > Here's a summary of the rules to have it refresh vs fill over again: ... > If primary key information is present, ...
    (microsoft.public.dotnet.framework.adonet)
  • Updating a field on a continous form
    ... which is bound to a read only recordset, ... If I set this field Unboundfield = ... Regards ... David Batt ...
    (microsoft.public.access.forms)