Search results

I meant OnLoad, but I have that frmQaulityCatches (data entry form). I hear you. I have a big cup of java. :)

That was on After Update, not on Open...

I compiled and found no errors.

I have tried everything under the sun that I am capable of doing... As for debugging, it work perfectly when I run the query, not sure if debugging will help. You're more than welcome to take a peek at it. See attached db.

Oddly, when I go into the form after the error messages, I select the Category and my date criteria, run the query and I get the results I am looking for...

OK, changed the Date to "DateCaught". Still get the same error. I also removed the # sign as well. Forgot about that.

Gotcha, I will try renaming Date to somthing like, "CauseDate". Thanks man, appreciate your help. Fingers crossed....

OK, I am trying to embed a chart in a form with the query looking up the Location and By Date I want to chart present. I Keep getting this error when the MS Access database engine does not recognize my criteria I set up in the query. I then hit "OK" and another error pops up stating an error...

OK, I seem to have resolved my issue. I basically did a work-around where I added a ListBox where I can reference back to the LocationCatrgory. Everything works except for one small issue. That is when I select the Location and Catch, it doesn't seem to show the value on some when I move...

What do you think pbaldy?

When I select Packing-DK, I'd like to be able to select (Note, these would also show up when if I were to select and other with a prefix of "Packing-") The other selections of course would see other causes to select from.:

I did try to create a query that includes all the data and that didn't seem to work either.

I could, but then I wouldn't be sort, create reports and graphs by Location (specific locations)... My reports would be too vague... Is there a way of doing what I am trying to achieve?

If you go into the tblLocationCategory table and change the Subdatasheet Name to Table.tblCatches, save it and open it. You should see catches associated with all 6 Location Categories. Let me know if you do not see that. Thanks for your time man.

hmmm, ok. Let me see if I can clarify the goal. I have a table that contains only general locations (tblLocationCategories). I have another table that contains specific locations (tblLocations) that grouped into general locations. IE: Final Test is broken down to Final Test-QL, Final...

Here it is. Left the data in it as there is nothing revealing in it. Thanks pbaldy

Yea, give me a few to rid the data

I have the code in the AfterUpdate event So I am trying to populate the cause by the Group location, not by a specific location as the specific locations will have the identical causes from the location groups.

OK, I so I am trying to filter one combbox tbltCatch from tblLocation (which is a sub filter from tblLocationCategory). Thing is, I am trying to select "Catches" filtered from the tblLocationCategory table. Reason being is because the "Catches" are the same the location types (example below). I...

Hey Minty, While I am waiting til you have time, I tried something and it still didn't work. Here it is: EmailRecipiantsList = DLookup("Notification_email_dept", "qryEmailTo", "[EmailType_ID] = 1") CC_List = DLookup("Notification_email_dept", "qryEmailTo", "[EmailType_ID] = 2")...