Dlookup function Help

[bronson_mech]

i have 2 tables 1)tblEmployee in that (Empname,Company,jobtitle, Reg HrsRate, Ot HrsRate)...... 2) Work Hours Subform in that( Empname,Company,jobtitle, Reg Hrs, Ot Hrs,Reg HrsRate, Ot HrsRate) here i need to get Reg Hrs Rate from table1 & input in Work Hours subform Reg Hrs Rate Using Dlookup Function......

i Tried

Private Sub Emp_Name_AfterUpdate()
Regular HrsRate = DLookup("Regular HrsRate", "tblEmployeesRate", "Empname=" & Empname)


End Sub

but its not working.......

pls help me to fix this................

[pbaldy]

I suspect this is what you're trying to do:

BaldyWeb - Autofill

If you want to stick with the DLookup():

DLookup Usage Samples

Noting the syntax for a text field, plus the inadvisable spaces in your names will usually require them to be bracketed.

[EddieN1]

You need double quotes (chr(34)) around empname... try

Regular HrsRate = DLookup("Regular HrsRate", "tblEmployeesRate", "Empname=" & Chr(34) & Empname & Chr(34))

[bronson_mech]

its not working.............

[RuralGuy]

Just curious: why do you have so many fields duplicated in the two tables? All you should need in the WorkHours table is the EmployeeID.

[pbaldy]

Just curious: why do you have so many fields duplicated in the two tables? All you should need in the WorkHours table is the EmployeeID.

+1 on that. Also what's not working exactly? Can you post the db here?

[EddieN1]

What about changing Reg HrsRate to [Reg HrsRate]... Eddie

What is value of "empName". If it contains double quotes, that will be a problem...

[bronson_mech]

only 1st line item value is displaying even if i select different value from combo box

Private Sub PIR_MOC_AfterUpdate()
WO = DLookup("WO", "tblProjectDetails", "ID=" & "ID")
End Sub

[pbaldy]

Were there quotes around the value in the link I posted?

[bronson_mech]

in pic 1 ..........if i select pir/moc it should give output in wo but if i take that quotes its giving me an error.......

[pbaldy]

Your field does not appear to be named "ID", and the error shows no value. Perhaps it should be:

DLookup("WO", "tblProjectDetails", "ID=" & Me.PIR_MOC)

But the method I posted earlier is more efficient than the DLookup(), and simpler IMO.

[bronson_mech]

Again 1 error

[pbaldy]

Is there a reason you don't just get the value from the combo row source? Can you post the db here?

[bronson_mech]

i can't able to upload......"upload failed".......... can u pls give me ur mail id , i'll send it through mail...........

[RuralGuy]

1st Compact and Repair your db. Then ZIP it up. That will allow you to attach it to a post. The limit for zip files is 2MB.