dlookup help please for dunce here (1 Viewer)

[murray83]

brain fade starting

ok have a table with people and shifts they be on so i have this dlookup

=DLookUp("ShiftNo","tblStaff","Colleague = Forms![Form2]!Combo4")

Which i would like to then display the shift in a text box but all i get is a big blank nothing, no error codes, no #error in my text box

please help, the shifts are numbers and strings is that maybe one issue, i need to streamline the data into one type

 

[Isaac]

What happens if you try:

=DLookUp("ShiftNo","tblStaff","Colleague = '" & Forms![Form2]!Combo4 & "'")

(if your ShiftNo field is a text datatype)

 

[murray83]

What happens if you try:

=DLookUp("ShiftNo","tblStaff","Colleague = '" & Forms![Form2]!Combo4 & "'")

(if your ShiftNo field is a text datatype)

it is a texttype and still blank see attached ( all tables included hehe )

 

[Gasman]

You need to decide what you are using for the combo?
The bound field is ID not Colleague !

 

[murray83]

You need to decide what you are using for the combo?
The bound field is ID not Colleague !

cheers, school boy error, blame it on it being late in the day

 

[theDBguy]

it is a texttype and still blank see attached ( all tables included hehe )

Hi. Pardon me for jumping in, but there's another approach, in your case, other than DLookup().