Change one unbound field on a continuous form view subform and they all change 
Author Message
 Change one unbound field on a continuous form view subform and they all change

Hi Everyone,

i have one main form, with a subform (continous form view) embedded on
it.

this subform has 1 bound fields and 1 unbound and displays 3 records.

i want to be able to address the unbound text field on record 2
programatically
but if i try, the unbound fields of the other 2 records also change.
this also happens when i type directly over "cat" in the form

id    desc (unbound)
11    dog
22    cat
33    fish

want to change just cat to salamander but get:

bound
id    desc (unbound)
11    salamander
22    salamander
33    salamander

i definitely need the unbound fields as they display read only data
not contained in the underlying table

help me pls, i need an URGENT fix

also.....

i would like to reference a single subform from a single collection of
subforms

as in

MyMainForm.MySubFormInContinuousView.item("the single subform i
want").MyUnboundTextField = "salamander"

is this possible?

regards

Edwina



Wed, 07 Dec 2005 06:00:48 GMT  
 Change one unbound field on a continuous form view subform and they all change

Quote:
> Hi Everyone,

> i have one main form, with a subform (continous form view)
embedded on
> it.

> this subform has 1 bound fields and 1 unbound and displays
3 records.

> i want to be able to address the unbound text field on
record 2
> programatically
> but if i try, the unbound fields of the other 2 records
also change.
> this also happens when i type directly over "cat" in the
form

> id    desc (unbound)
> 11    dog
> 22    cat
> 33    fish

> want to change just cat to salamander but get:

> bound
> id    desc (unbound)
> 11    salamander
> 22    salamander
> 33    salamander

> i definitely need the unbound fields as they display read
only data
> not contained in the underlying table

Even in continuous view there is really only one unbound
control on your form.  The others that you *see* are just
copies of the one.  There is no way to make an unbound
control be different per-row on a continuous form.   Can't
you use a query and add the data not in the table using an
expression?


Wed, 07 Dec 2005 07:11:56 GMT  
 Change one unbound field on a continuous form view subform and they all change
Hi Rick,

thanks for your reply.  the problem is i also want to bind some fields
so that they automatically add to the underlying table.  if my query
includes the other info from the other tables, when i try to add a
records i get one of two errors:

* recordset not updateable or,
* records added not just in my target table, but the other lookup
table as well!!

this last being higly undesirable.

however, your comments have given my an idea re redesigning what i
want to do.

regards

Edwina



Thu, 08 Dec 2005 06:43:51 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Change subform view from continuous to single in code

2. Changing color of one field on datasheet view of form

3. Solution: Changing Forecolor for one Record on Continuous Subform

4. Solution: Changing Forecolor for one Record on Continuous Subform

5. Solution: Changing Forecolor for one Record on Continuous Subform

6. Continuous form view for Unbound forms?

7. Continuous subform - change color of fields in current record

8. VB code to change continuous subform to single form

9. background color won't change in subform control (default continuous form)

10. Changing Text on One record on a Continuous sub form


 
Powered by phpBB® Forum Software © phpBB Group