Hi,
    I'm using Dlookup function to return a value.
E.g

Dim strName as string
me.txtName.value=strName

If strName = Dlookup("[EmpName]","EmpTable","[EmpID]=" & 1) then
....

[EmpName] and [EmpID] are 2 colummes from the table. If strName matches the [EmpName] in the EmpTable, i should get the corresponding EmpID nos and compare with the value, e.g 1 in this case. But it is not working if there are 2 or more similar value in the EmpID field.

Pls kindly advise or how should my statement looks like?? Thnks alot.

Rgds,
Andy

I would set the variable value like this:

strName = Me.txtName.Value

Why would there be 2 or more duplicate values in the Primary Key column?



mmcdonal

Hi,
   I set '1' for some users in the primary key and '2' for the others.
Supposingly, if dlookup return '1', a set of operations with be carried out whereby if return '2' another set of operations with be carried out.... but it is not working if there are more than 2 similar value in the same field.

Rgds.

That is your problem. You are not properly using the Primary Key field.

If you have a column that you want either 1 or 2 in, use a check box which will store the values 0 and -1, then use those for your functions.

Use the PK field as a unique identifier. This function that you are attempting will not work until you insert an autonumber PK field into your table.



mmcdonal