OnClick event to view Total Count records

[wnicole]

I created a query that give me Total Count of invoices in a particular type of job. I made a datasheet form. Now I want to click on the TotalCount of records to open the form to view only the records in that type of job. THis is what I'm using but its not working. Can you tell me what I'm doing wrong?

DoCmd.OpenForm "datasht_AllInvoices", , , "[Type of Job]=" & "'" & [Type of Job] & "'"

[ItsMe]

Is [Type of Job] text vs. numeric? Because your code is set up as if it is text type.

Maybe save the datasheet form before executing the DoCmd and or use Me.[Type of Job].Value in your statement.
DoCmd.OpenForm "datasht_AllInvoices", , , "[Type of Job]=" & "'" & Me.[Type of Job].Value & "'"

[wnicole]

Yes it is a text, however I forgot to tell you that it is also a listbox. Would that change the code?
FYI...I did use DoCmd.OpenForm "datasht_AllInvoices", , , "[Type of Job]=" & "'" & Me.[Type of Job].Value & "'" and still didnt work...
Do you think the fact that Type of job is a listbox?

[ItsMe]

If the ListBox has its Multiselect property = to Yes, you will need to iterate the control. Here is an example.
https://www.accessforums.net/forms/l...tml#post276307

If it is not a multiselect listbox, I believe you can use the .Value property to retrieve the selected. You just need to be sure to set the Bound Column property to the correct column.

[wnicole]

Sorry I think this one is over my head :-(

[ItsMe]

Perhaps you can test which element the user selected by using a msgbox. Maybe place the following code in the AfterUpdate event of your ListBox Control.

msgbox Me.[Type of Job].Value