ok this is my code:
Dim LTotal As Long
LTotal As Long
LTotal = DCount("OfficeWeekReceived", "Contacts", "")
Text189.Text = LTotal
Now OfficeWeekReceived (it's a combo box) can have a value of 1, 2, 3, 4, 5, or 6. I want it to be able based on the user's selection of 1-6 for it to count...