Subform Add record

[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

 

[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.

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.

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 <--

 

[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

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

 

[Hank]

Just what I needed,
Thanks Stefan

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 <--

 

[Guest]

hey stefan..

thanks.. i benefit too from ur codes.. tnx..

marc