Subform Add record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hank - 15 Nov 2006 15:45 GMT

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

Reply to this Message

Stefan Hoffmann - 15 Nov 2006 16:02 GMT

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

Reply to this Message

Hank - 15 Nov 2006 19:15 GMT

Just what I needed,
Thanks Stefan

> hi Hank,
>
[quoted text clipped - 15 lines]
> mfG
> --> stefan <--

Reply to this Message

amsuria - 16 Nov 2006 06:04 GMT

hey stefan..

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

marc

> hi Hank,
>
[quoted text clipped - 14 lines]
> mfG
> --> stefan <--

Reply to this Message

Bob Hairgrove - 15 Nov 2006 16:08 GMT

>I created a form with at subform using the wizard. It worked fine -
>including the ability to add new records to the subform.
[quoted text clipped - 5 lines]
>
>Hank

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

--
Bob Hairgrove
NoSpamPlease@Home.com

Reply to this Message