Hi,
I have a form that when the next button on the previous form is clicked, it grabs the value of a combo box from the previous form and uses it to fetch the FullName field in one table.(DLookup)
Then from the same value from the previous form fetches the record count of another table.
Not sure what I'm doing wrong here. Here is my button code and the DLookup and DCount that I have as the Control Source.
=DLookUp("[FullName]","Standard_Actions","[UserID] =" & [Forms]![Edit_Existing_Plan]![SelectUser])
=DCount("*","Meal_Categories","UserId =" & [Forms]![Edit_Existing_Plan]![SelectUser])
Any help would greatly be appreciated.
I have a form that when the next button on the previous form is clicked, it grabs the value of a combo box from the previous form and uses it to fetch the FullName field in one table.(DLookup)
Then from the same value from the previous form fetches the record count of another table.
Not sure what I'm doing wrong here. Here is my button code and the DLookup and DCount that I have as the Control Source.
Private Sub Next_Click()
DoCmd.OpenForm "Edit_Existing_PlanwithStatus", acNormal
DoCmd.Maximize
DoCmd.Close acForm, "Edit_Existing_Plan"
End Sub
DoCmd.OpenForm "Edit_Existing_PlanwithStatus", acNormal
DoCmd.Maximize
DoCmd.Close acForm, "Edit_Existing_Plan"
End Sub
=DLookUp("[FullName]","Standard_Actions","[UserID] =" & [Forms]![Edit_Existing_Plan]![SelectUser])
=DCount("*","Meal_Categories","UserId =" & [Forms]![Edit_Existing_Plan]![SelectUser])
Any help would greatly be appreciated.