Pass value from subform control to query

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Found the correct wording for searching this topic - no reply needed, thanks.
 
You must log in or register to reply here.

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

Searching Form and Subform 4
go to mainform from subform on selected record 1
hope this is an easy one for somebody 5
Passing textbox data into String for URL 8
query in a form to a report 1
Search form with multiple controls 7
adding and removing subforms from subform controls 4
Passing a value from subform or main form to subform query 4

Back
Top