If then statement using Yes/No criteria

[jpiazza]

Background - When a button is clicked - I want it to goto 1 of 2 forms based on whether a person is a manager or not. I have a field 'Approver' in the Employees table that is a check box (yes or no).

however when I click on the button it gives me an error that says - "The object doesn't contain the automation object 'Employees' "

its having an issue with this line that's underlined: - what is wrong with this?

If [Employees]![Approver]=True Then
Open form for Managers
Else
Open form for Non-managers


End

Thanks for any assistance !

[Bob Fitz]

If the form that holds this button is bound to the Employees table, try:
If Me.[Approver]=True Then

[jpiazza]

the form isn't bound to the table. When I put in Me.[Approver]=True - it changes the Me to [Me].[Approver]=True and get the same message.

[Bob Fitz]

In that case, perhaps you could use DLookup() to return the value of the "Approver" field. See: http://www.techonthenet.com/access/f...in/dlookup.php

[jpiazza]

Thank you - that worked. However I'm not sure if this is giving what I'm looking for. I'm trying to evaluate whether or not the field [Approver] is checked or not.

The If Then statement now says

If DLookUp("[Approver]","Employees","approver=yes") Then

Approver is a check box - yes/no - yes the person is an approver/Manager.
When the criteria ie: approver box is not checked, it should goto the ELSE side of the If..Then statement, but doesn't.

How do you indicate this ?

Thanks again.

[Bob Fitz]

No. I'm sure this is not what you need. The criteria argument of the function should should be used to find the only record from which you want the Approver value returned. I assume your Employees table has a Primary Key field, lets say it's called EmpID. The criteria would then be "[EmpID] = " & Me.textBox if EmpID is numeric. In this example "Me.txtBox" would be a control on the form which has the EmpID value of the person you want to evaluate.