adding into subform in a query form

  • Thread starter Thread starter Sansanee
  • Start date Start date
S

Sansanee

Hi,

I am wondering if anyone can tell me how I can add data into a subform field
of a main form that query the id. In my main form, I have a dropdown listbox
for clientID and I want to add additional records into the subform but I get
the error said that the addition is not possible with out updating the
clientID.

Thank you in advance,

Sunny
 
Hi,

I am wondering if anyone can tell me how I can add data into a subform field
of a main form that query the id. In my main form, I have a dropdown listbox
for clientID and I want to add additional records into the subform but I get
the error said that the addition is not possible with out updating the
clientID.
Click to expand...

What are the Recordsource properties of the main and subform? What's
the Master/Child Link Field? Should the Client ID by the master/child
so that it will fill in automatically?

John W. Vinson[MVP]
 
Hi John,

The recordSource of the main form is a table and the subform is a query.
Master/Child Link field is ID. The ID is a combo box that has a recordSource
from a query so it display ID, name, etc. as well.

Thank you,

Sunny
 
Hi John,

The recordSource of the main form is a table and the subform is a query.
Master/Child Link field is ID. The ID is a combo box that has a recordSource
from a query so it display ID, name, etc. as well.

Thank you,
Click to expand...

Ok... so what specifically is the problem?? Sounds like it's working!

John W. Vinson[MVP]
 
It is allowing me to add into the subform. It sent out the error that the
update is not possible without the update in mainform.

Sunny
 
Back
Top