Subform Add record

H

Hank

I created a form with at subform using the wizard. It worked fine -
including the ability to add new records to the subform.
I could not display a "Total" text box on the footer using the datasheet
view of the subform. When I changed it to a continuous or single form - I
can use the "Total" text box, but cannot add new records to the subform.

What am I doing wrong.

Hank
 
S

Stefan Hoffmann

hi Hank,

wrote:
I created a form with at subform using the wizard. It worked fine -
including the ability to add new records to the subform.
Click to expand...
What do you mean with "the ability to add new records"?
I could not display a "Total" text box on the footer using the datasheet
view of the subform. When I changed it to a continuous or single form - I
can use the "Total" text box, but cannot add new records to the subform.
Click to expand...
Place the 'Total' Textbox in the form footer, call it txtTotal. Save
your form with your datasheet view.

Place a new Textbox on your main form. Its ControlSource must be
"=SubFormName!txtTotal".


mfG
--> stefan <--
 
B

Bob Hairgrove

I created a form with at subform using the wizard. It worked fine -
including the ability to add new records to the subform.
I could not display a "Total" text box on the footer using the datasheet
view of the subform. When I changed it to a continuous or single form -I
can use the "Total" text box, but cannot add new records to the subform.

What am I doing wrong.

Hank
Click to expand...

Try putting the Total text box in the main form, not the subform's
footer.
 
H

Hank

Just what I needed,
Thanks Stefan

Stefan Hoffmann said:
hi Hank,

wrote:
What do you mean with "the ability to add new records"?

Place the 'Total' Textbox in the form footer, call it txtTotal. Save your
form with your datasheet view.

Place a new Textbox on your main form. Its ControlSource must be
"=SubFormName!txtTotal".


mfG
--> stefan <--
Click to expand...
 
Top