In reply to Garry Smith: It's been a year but in case someone else looks at this and wonders themselves, the answer you were given was almost right. You DO need single quotes around the value of txtGetItemNum and you would format it the way Richard showed.  But you do NOT need quotes around the control name.  Quotes go around text VALUES, not the controls and variables that hold the values. So the last part of the DLookup would look like this: "GalleryItemID= '" & txtGetItemNum & "'")

---

Reply from Alex Hedley:

Thanks for pointing it out.
(I think it was a typo/copy and paste job)