Recent content by greenfch

I feel so stupid. It is my Monday. Thanks again. Cheers back atchya,

Thanks for you rapid reply, eugin. This is a multiselect listbox, that is why the variant. I should have said: stlinkcriteria is returned as [LLQID] = '1' instead of [LLQID] = 1 as what works in my criteria. It was not meant to appear as code.

I am attempting to get the values from a multiselect listbox (access 2003) where the listbox contains 2 columns. the viewable text (column 2) and the associated number (column 1) to use as criteria in a report. the code I am using is close but produces exclamations around my number as if it were...

Hello everyone. I have been benefiting from this site for years but have not needed to register until now. I am a Mechanical Designer but have been programming access db's as a hobby for 15 years. I don't know much about forums except how to search from Google. Here it goes. :cool: