Open form using id from drop down as parameter

[Ruegen]

I have a combobox on a form with given areas



I would like the button to retrieve the combobox area id and then open the form using it

I was thinking

DoCmd.OpenForm "frmSchools", , , "AreaID = Me.cmbAreaSelector"

The combobox is unbound.

I of course get erros.

Picture

[Ruegen]

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?

[Ruegen]

I used a TempVars! in the vba - after adding it to the combo box "on change"

Works

[June7]

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

[Ruegen]

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

Yup, that works a lot better than my method - thanks June