Populating a continuous form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

on my main form i have a continue button that i want to run a query based on
the current value of 2 combo boxes and then populate the results into the
appropriate fields in my continuous form howeever i need to run a different
query for different values of the 2 combo boxes. I hope that explains
everything.
 
Awolfi,

If I understand you correctly, the code could be something along these
lines...

If Me.OneCombo = "x" And Me.OtherCombo = "y" Then
Me.MySubform.RecordSource = "A Query"
ElseIf Me.OneCombo = "a" And Me.OtherCombo = "b" Then
Me.MySubform.RecordSource = "Another Query"
End If

If this doesn't help, can you post back with some further details,
including examples?
 
Back
Top