Search results

I get the subject run time error when I try to past a record. The error reads: "The value you entered doesn't meet the validation rule defined for the field or control." Then it takes me here in the VBA: Private Sub cboEmployee_AfterUpdate() Me.RecordSource = "qryHours" Me.Refresh...

CardGunner, Yes it is built on a query.

Instead of Form.Refresh Try Me.Refresh

I am using a continous form for time keeping purposes. It looks somewhat like this: Project | Week | Mon | Tues | Wed | Thur | Fri | Comments| ABC |03/31/08| 1 | 0 | 3 | 2 | 0 | Design Work | XYZ Etc The form displays the last month's worth of work. I would like...

Sorry, I've only played with them, but looking at your code that was the first thing that came to mind.

Have you tried using a pivot table?

Mike375, Thank you. Now I only have to update one file and it works for everyone! What a time saver! SeaRox

Mike375, Thanks for the help. It sounds like you have an idea that will work for me. I'm not familiar with setting conditions. Can you point me to some example code I can modify to get these results or maybe a wiki on setting conditions?

All: What I'm trying to do: I want to be able to use a switchboard button (or a button on a form) to open a unique form. OK, true, that's easy. Here is where I am having trouble. I want that one click to set the title of the form and the criteria for the query of a subform. Basically I want...