Auto create record in subform NZ is not working

[Ken Ivins]

I have a form with participants to an event and their billing information.
On it is a subform for multiple payments to this event. To get a balance due
report I need to have some figure as a payment (even if is zero). How do I
automatically create a record in this subform when ever a participant is
created or is there a better way to do this.

Peter Walker suggested I try the Nz function which sounded good.

I tried the following code on a field on the main form and got an "Object
doesn't support this property or method" error.

Private Sub txbLastNam_AfterUpdate()
Me![sfrmConferencePayment].[txbPaymentAmt] =
Nz(Me![sfrmConferencePayment].[txbPaymentAmt], "0")
End Sub

I assume this is because there is no record created yet, but maybe I'm
wrong. I'm looking for ideas.

Thanks,
Ken

[Mike Painter]

"Ken Ivins" <ken-27@spa.net> wrote in message
news:OOnt6WyRDHA.1720@TK2MSFTNGP12.phx.gbl...

> I have a form with participants to an event and their billing information.
> On it is a subform for multiple payments to this event. To get a balance

due

> report I need to have some figure as a payment (even if is zero). How do I
> automatically create a record in this subform when ever a participant is
> created or is there a better way to do this.
>
> Peter Walker suggested I try the Nz function which sounded good.

At some point in the process or before you save the master record
I assume you have an autonumber for the record key.
docomd.runsql "INSERT INTO Billing (ParticipantID,SomeAmountField) VALUES ("
& Me!ParticipantID & ",0);"

[Ken Ivins]

Mike,

With some other coding to get it to save first, this worked.

Thanks,
Ken



"Mike Painter" <mpainteratattdotnet> wrote in message
news:3a80b97e68b0795c907faec4abc3eff7@free.teranew s.com...

>
> "Ken Ivins" <ken-27@spa.net> wrote in message
> news:OOnt6WyRDHA.1720@TK2MSFTNGP12.phx.gbl...

> > I have a form with participants to an event and their billing

information.

> > On it is a subform for multiple payments to this event. To get a balance

> due

> > report I need to have some figure as a payment (even if is zero). How do

I

> > automatically create a record in this subform when ever a participant is
> > created or is there a better way to do this.
> >
> > Peter Walker suggested I try the Nz function which sounded good.

>
> At some point in the process or before you save the master record
> I assume you have an autonumber for the record key.
> docomd.runsql "INSERT INTO Billing (ParticipantID,SomeAmountField) VALUES

("

> & Me!ParticipantID & ",0);"
>
>

[Mike Painter]

Not sure what that means. The statement does insert a record and all you
would have to do is refresh the view.
"Ken Ivins" <ken-27@spa.net> wrote in message
news:u2xUas%23RDHA.2676@TK2MSFTNGP10.phx.gbl...

> Mike,
>
> With some other coding to get it to save first, this worked.
>
> Thanks,
> Ken
>
>
>
> "Mike Painter" <mpainteratattdotnet> wrote in message
> news:3a80b97e68b0795c907faec4abc3eff7@free.teranew s.com...

> >
> > "Ken Ivins" <ken-27@spa.net> wrote in message
> > news:OOnt6WyRDHA.1720@TK2MSFTNGP12.phx.gbl...

> > > I have a form with participants to an event and their billing

> information.

> > > On it is a subform for multiple payments to this event. To get a

balance

> > due

> > > report I need to have some figure as a payment (even if is zero). How

do

> I

> > > automatically create a record in this subform when ever a participant

is

> > > created or is there a better way to do this.
> > >
> > > Peter Walker suggested I try the Nz function which sounded good.

> >
> > At some point in the process or before you save the master record
> > I assume you have an autonumber for the record key.
> > docomd.runsql "INSERT INTO Billing (ParticipantID,SomeAmountField)

VALUES

> ("

> > & Me!ParticipantID & ",0);"
> >
> >

>
>