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: reverson@maintainer.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___