Search results

That'll work even better. Saves some time too. Thanks again, Paul. Much appreciated.

OK... that helped. I discovered what was going on. I have other controls on the same form that were null. The other controls need to be deleted from the form in order to get the code to work. That should do it. Thanks again for your assistance!

When the controls are populated, the message box appears nonetheless and the queries fail to run... doing what I told it to do, unfortunately.

Hi Paul, That's where I put it... Looks like this: Private Sub Command8_Click() Dim ctl As Control For Each ctl In Me.Controls Select Case ctl.ControlType Case acTextBox, acComboBox, acListBox, acCheckBox If Nz(ctl.Value, vbNullString) = vbNullString Then...

Oh, so true! That said, I should have tested this before my reply earlier... If the fields ARE populated, it won't progress to the query string. What am I missing? Thanks again!

That did it. Thanks much for your reply!

Hi all, I am trying to run code through a form to ensure fields are populated. If the fields are populated, the code needs to allow a series of queries to run. If not, the code should stop the user cold until the fields are populated. Here's the code thus far... Private Sub...

I have a report that includes several subreports. I would like the option to exclude one or more of the subreports. I have included a column in the table to record whether a checkbox on the applicable form is checked or not. If the form is checked and thus recorded in the table, the intent is to...

DCB, that worked like a charm. Excellent. Thanks again.

Thank you! I'll try that as well. I meant to say "Job Code" as opposed to "Employee ID" throughout. Thanks for catching that. Really appreciate it.

Thanks much for the response. I've used forms that have calls like this in the past and oddly, it didn't dawn on me to try that. I'll give that a try. Thanks again!

Correct... it opens the query, but what I want it to do is open the query referencing a specific parameter... in this case the employee ID which is embedded in the form on which the button calling the code exists. Thanks!

I am trying to use a DoCmd.OpenQuery command to open a query referencing an employee ID from a form. Opening a report and using a macro, the "Where Condition" code looks like this: [Forms]![frmMainInput]![frmSummary_Subform].[Form]![Job Code]=[qryCheckResponsibilities]![Job Code]. I have...