Refering to a query using a combo box

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

Guest

I have a query which uses the selectdate function to pick out different months, I also have a form which the query shall be in as a subform. This form contains a combo box which contains the month names as well as the relevant numbers 1 through to 12 which are associated with the selectdate. Is it possible to make the criteria for the two selectdate columns (due to the information coming from two different tables) the number from the combo box?
Any help would be much appreciated
 
What is the selectdate function?

You can refer to a control on a form by using the syntax of:

Forms!FormName!ControlName
e.g. Forms!frmStuff!cboStuff


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Flic said:
I have a query which uses the selectdate function to pick out different
Click to expand...
months, I also have a form which the query shall be in as a subform. This
form contains a combo box which contains the month names as well as the
relevant numbers 1 through to 12 which are associated with the selectdate.
Is it possible to make the criteria for the two selectdate columns (due to
the information coming from two different tables) the number from the combo
box?
 
Back
Top