I'm guessing I will have to store the value as a temp var in order to store the value for the parameter on the other form?
I used a TempVars! in the vba - after adding it to the combo box "on change"
Works![]()
I've never used TempVars.
Problem with your original code is the variable is within quote marks. That results in the literal string "Me.cmbAreaSelector" instead of the value in Me.cmbAreaSelector. Must concatenate variables, not enclose in quotes.
DoCmd.OpenForm "frmSchools", , , "AreaID = " & Me.cmbAreaSelector
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Yup, that works a lot better than my method - thanks JuneI've never used TempVars.
Problem with your original code is the variable is within quote marks. That results in the literal string "Me.cmbAreaSelector" instead of the value in Me.cmbAreaSelector. Must concatenate variables, not enclose in quotes.
DoCmd.OpenForm "frmSchools", , , "AreaID = " & Me.cmbAreaSelector![]()