Recent content by Seecott

It should probably be something like this. xTimer = DLookup("Timer", "tbl_ref_assignment", "AssignmentID = " & Me.AssignmentType) You can add Nz() around Me.AssignmentType just incase it's null.

awesome! Thanks!

Hello, I incorporated MSFlexGrid into my MS Access form to have the ability to color code rows/columns. I can't seem to find a wayto right-click and have the memu popup. The method PopupMenu does not seem to exist in MS Access VBA. Here is my sample code. I hope someone can provide me with an...