Selasa, 12 Januari 2016

RE: [MS_AccessPros] Can't figure out my RS is blank


Thanks Liz,

I did but couldn't figure out how to make that work either.... for example, I tried 3 different ways:

If DLookup("MyTruckTypes", "TRUCK_TYPE", "MyTruckTypes = '" & Me![TRUCK_TYPE] & "'") Then
If DLookup("MyTruckTypes", "TRUCK_TYPE", "MyTruckTypes = " & Nz([TRUCK_TYPE], 0)) Then
If DLookup("MyTruckTypes", "TRUCK_TYPE", "MyTruckTypes = " & [TRUCK_TYPE]) Then

Regards, Rohn


Posted by:
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)



Tidak ada komentar:

Posting Komentar