Parameter change using Query

D

Dave Hawks

I have a subform frmqerTeeTimes , based on a query qerTee Times. The subform
is linked to the main form "frmCompetitionMasterData" by the field "fldDate".
The data displayed in the subform is a range of times given by the selection
criteria (Between#07:30# and #16:00#)for the field "fldTeeTimes".
Question
Can I attach a query to the on current event of the subform that will change
the selection criteria as the user scrolls though the records in the main
form based on another field in the main form fld CompCode.
I can use the following to track the changes in fldCompCode,
On Current
If Forms![frmCompetitionMasterData]![fldCompCde]="M" Then
some query to change criteria in fldTeeTime in query qerTeeTimes
Else
End If
Can anyone help please
 

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

Format Subform 0
Passing a value from subform or main form to subform query 4
Setting field value if a value exists in another table 3
Form changes not being saved to table 1
change query criteria dynamically with value from a 2nd form 1
Specify date criteria for subform data 11
Use value on main form for criteria on subform 1
Subform issues with combo box 8

Top