Trouble setting Temp Var

[ct2013]

Hi there,

I have a table [Employees] which has the following Fields

- TxtEmpID

- StrEmpName

- StrEmpPassword


Which I use for my login table with the following script:

If Me.txtPassword.Value = DLookup("strEmpPassword", "tblEmployees", "[TxtEmpID]=" & Me.cboEmployee.Value) Then

TxtMyEmpID = Me.cboEmployee.Value

On my form the drop down to select the employee is “SELECT tblEmployees.[TxtEmpID], [tblEmployees].[strEmpName] FROM tblEmployees; “ (Seemingly all this is based on the TxtEmpID)

When I create a Temprorary Variable [SetTempVar – screen.activecontrol with the name “SetUserID”] and then want to place the variable in a form or whatever else, I can only see the TxtEmpID. I would like to set the TempVar as the field StrEmpName.

How is this possible??

Please reply ASAP
Many thanks

 

[RuralGuy]

The StrEmpName is the 2nd column of your ComboBox.

 

[ct2013]

thanks,

it is the second column on my drop down.

how would i place it into this script?

TempVars.Add ???, "??"

 

[ct2013]

Many thanks for your reply.

Unfortunately I cant get that code to work.

attached is my sample DB. could you possibly let me know where I am going wrong.

Thanks a mill.

 

[ct2013]

Sorry unsure what you mean, Is it not code?I don't think I worked on macros on my logging in for?

 

[ct2013]

Thanks for your response,

Is it a big job for you to change this as I am happy for you to change whatever necessary to get this working.

Thanks for all your help

 

[ct2013]

Hi there,

I have done that now, would you mind to try and look at it again.

Thanks a mil:banghead: