Affichage des articles dont le libellé est Customizing Access parameter Query - No Data. Afficher tous les articles
Affichage des articles dont le libellé est Customizing Access parameter Query - No Data. Afficher tous les articles

Customizing Access parameter Query - No Data

mercredi 22 avril 2015

Hello, I don't want my user to type in the parameter value for a query in case of miss spelling. Therefore, I'm using a dialog box form with a combo box field. The row source of the combo field is a table with one field for the list. I've added VB code (Event Procedure) to a buttons on the dialog box which says to run a query after click. I've created the query for the info I need displayed and am using the forms combo field as the criteria.

Private Sub cmdOK_Click()
DoCmd.OpenQuery "qryRequestsbyBranch", acViewNormal, acEdit
DoCmd.Close acForm, "frmDepartmentList"
End Sub

The query runs except I'm not getting any data. I'm not sure what I'm missing.
Do you have any ideas?

Thanks so much for your help!
Customizing Access parameter Query - No Data

Labels