Recent content by pilmart

Nope the columns are fixed

Hmmm, I think you will have to load the text box from the recordset (rst) Something like Reports![myReport].text0.controlsource = rst.fields(0).value. This won't work in my case as I'm loading my report recordsource with a dynamic sql statement not loading a recordset as per your example, I...

...forgot to add using access 2003 on XP box

Hi There I have a form on which I construct a string containing a dynamic query, the string containing the query is then passed to a report, the report recordsource is then set to the query string and the report opened. My question is how can I access (Sorry 'bout the pun) :) individual...