Selecting "All" in a combobox

[NeoPa]

CVincent78:
Do I add this into the rowsource SQL code or the Query SQL code?

You have to understand what is being explained here and use this understanding to create the SQL used to filter your object, whatever that is, that needs to be filtered based on this selection.

This could be by setting a .Filter property of a Form or Report, or it could be to change the WHERE clause of some query.

Only you know what that is, but the concept has been explained clearly and it's now down to you to understand that and build on what you have with that new understanding.

We aren't here to spoon-feed you. At some point you need to grab the concept and go with it. That's now.

We can still help, but we do expect you to get with it and start to work things out for yourself when you can. We're pretty well at that point now.

[cvincent78]

Thanks guys.. going to tackle it this weekend.

I will let you know how it works out.

[NeoPa]

8-)
Good luck :-)

[cvincent78]

Alright got it! Looks like my original code as well as NeoPa's code in the SQL builder was correct all along :)
My problem was my subform was a report I used to build a chart. Once I deleted the subform and added a chart using the Query (Qry_EngHoursby Division) directly on the main form (Frm_MainPage) everything worked perfect.

Hope that made sense folks... appreciate everyone's time. Guessing this is the reason everyone else's solution didn't work, but I don't have the time to look into it today.

C.

[NeoPa]

Glad to hear it's all working well now.

Cheers.