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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query Won't Run 0
Multiple Queries / Same Criteria 3
Exicute an append query in an after update event 0
User Input 1
query to filter records 2
Need help getting query to reference a field in a subform 2
Adding into a parameter query in main form 3
The incredible returning query criteria! 3

Back
Top