entering dtaa in the parameter query

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

Sansanee

I am having a main form and a subform in which the main form has query for
ClientID but I am wondering if anyone can tell me what code I should use to
allow user to add into the subform.
 
I am having a main form and a subform in which the main form has query for
ClientID but I am wondering if anyone can tell me what code I should use to
allow user to add into the subform.
Click to expand...

No code is necessary, provided the subform's recordsource query is
updateable. Normally you would use the ClientID as the master/child
link field of the subform (rather than a separate query); this will
allow the user to enter data and have Access automatically fill in the
ID.

John W. Vinson[MVP]
 
Back
Top