Loading a form/Subform for a new record

C

CanFlightSim

I have a client database where I have a command button on the Customer
Info form that on click it will open another form and load the client
info on that form.

Two things are wrong:
I get two records on my new form, one with the client information and a
blank one.
My form is on the blank one.

In addition I do not have a new record in the subform.

The code looks right. What am I missing?

Thanks for your help in advance.
Will
 
J

John Vinson

I have a client database where I have a command button on the Customer
Info form that on click it will open another form and load the client
info on that form.

Two things are wrong:
I get two records on my new form, one with the client information and a
blank one.
My form is on the blank one.

In addition I do not have a new record in the subform.

The code looks right. What am I missing?
Click to expand...

The code looks a bit blurry from here. Could you perhaps post it?

Also what is the Recordsource of the new form, and the subform? For
the subform, what are its Master and Child Link Field properties, and
what is it a subform OF?

John W. Vinson[MVP]
 
Top