Recent content by Ellerd

Thanks Bill I was able to get mine working. I used your AfterUpdate code on the cboBoxes. And changed the open form command button so it didn't apply any filters (this probably was the problem). With my three criteria field it opens a form that has 8 other field shown based on those...

Bill I was able to down load it and your Find screen is what I'm trying to do, when field are blank all data is shown. I couldn't get to the code to see have it was done. Thanks Denny

Bill I went to Thread181-620597 and found the buttons file but I couldn't down load it as it was not found. I was able to down load some of the other files that looked interesting.

I sent the db home where I have Access2000. You were correct none of the * querries work, it must of been some sort of querk in 97 that it works sometimes. I think I will have to make 3 differnet querries with no criteria in the field I wall "All" reported. thansks for the help/

I missed typed the original message, the criteria I put in the query was as you suggested[Forms]![FrmCrit]![cboItemType] & [Forms]![FrmCrit]![cboJobType]. From your first response I felt that the query was taking the * literally and that was why it didn't work but when I opened the report...

I understand what you are saying but I'm not sure how to accomplish it. The 2nd form that is opened from the command button when I created it I selected on filter so it takes the selection from the first form or actually from the query. Is there some place to set what you are talking about?

I have created a form (FrmCrit) that has three boxes in it. Two are combo boxes and the other is a text box. The first combo box, cboJobType, selects the type of job you want to sort by from the list. The second combo box, cboItemType, selects the item type from the list. The text box...