Pass value from subform control to query

L

Lungta

On frmCase we have a button to run a Word merge letter (while the form is
open). The code runs qryLetters where
[qryLetters].[CaseID]=frmCase!txtCaseID. (frmCase is not bound to qryLetters)

frmCase has a subform (sfAppt, continuous form view) to capture the
professional assigned to the case. Only 1 will ever be assigned at any given
time, and this professional is the person getting the merge letter.

Occasionally one prof. backs out and a new one is assigned, so there are 2
records then showing in the subform.

How would I change my "where" portion of the SQL to include
CaseID=frmCase!txtCaseID and the desired record in sfAppt? Would a combo or
checkbox to flag "current" be useful, or would it just flag the same on all
records in sfAppt?

Thanks for any suggestions you might have.
 

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

hope this is an easy one for somebody 5
query in a form to a report 1
main form/subform 1
adding and removing subforms from subform controls 4
Referring to control in the active subform 0
Matching from a form to a subform 1
return Subform Name on Tab control 2
Change caption on continuous subform 3

Top