Pass value from subform control to query

G

Guest

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
Word Merge SQL syntax 1
Change caption on continuous subform 3
adding and removing subforms from subform controls 4
Pass Subform filter to subform in report 0
Matching from a form to a subform 1
email from subform 8

Top