Automatically copy text from form into subform!?

J

Jole

Hi Can someone help I have no programming skills....

I have a form and a sub form. The main form is called Cash and the sub form is called SubCash.

Please note that the fields I want to copy from the main form (CASH) are unbound fields because there just calculations totals. I want to copy them into the subform (SubCash) which will have Bound fields holding them. Can someone provide the code

There are currently 7 fields in Cash form: TextBox1-TextBox7 I would like simply duplicate the unbound fields into the subform

If so is there anyway to refresh this form?

A BILLION THANKS

Jol
 
M

Mike Painter

Jole said:
Hi Can someone help I have no programming skills.....

I have a form and a sub form. The main form is called Cash and the sub form is called SubCash.

Please note that the fields I want to copy from the main form (CASH) are
unbound fields because there just calculations totals. I want to copy them
into the subform (SubCash) which will have Bound fields holding them. Can
someone provide the code?
There are currently 7 fields in Cash form: TextBox1-TextBox7 I would like
simply duplicate the unbound fields into the subform.
Without an explanation of what you are doing and the reason for unbound
fields in a main form and no mention of what the relationship between the
main and subform are I would only have one place to start.
It sounds like you have a badly designed database.
"Like" fields as Textbox1, TextBox2,.... is almost always are a sure sign of
this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top