Recent content by rondon

Thank you this has worked, and thank you to everyone else who contributed to this thread

Hi DBguy I was not clear sorry the comma appears ok in the query it is when I set a field with the control source to the Module then the comma appears

Yes both examples did

Yes thankyou it is working now, I am just trying to work out why it is showing a comer at the start, the code line If strtext = " " Then strtext = rs!AgencyName Else strtext = strtext & ", " & rs!AgencyName End If Should prevent this was my understanding...

Yes but not sure I was putting it in the right place as I couldn't get it to work

Hello June 7 Is it possible to add a SELECT statement to limit duplicate records appearing

T Thank you this worked, as did the solution by the DBguy. I will try to use this example as I can understand it a bit clearer. However I still have one issue, if the same agency is assign to a ReportID more than once it displays serval times in the field. Is there a way we can not show...

Please find a condense version of the DB I placed your code into my module and the same error message occurred when I opened form frmReviewReportID. This is the form that has the field txtConcatList() where I would like the agency names passed to. I hope this helps Thanks Ron

Code Tags Added by UG Please use Code Tags when posting VBA Code Please read this for further information:- https://www.access-programmers.co.uk/forums/threads/please-use-code-tags-when-posting-vba-code.240420/ Please feel free to Remove this Comment 'Please find the code below Option...

HI I looked at the video and web page and it certainly simplified my understanding of the process. I copied the SQL statement from my query and inserted it in to the code (=fConcatList()) which I typed out to get a better understanding of. I set the text field...

when I look at the code I not quite sure where to put those in

Yes I have study this but found it a little complicated for my level of coding

I have a query named qryAgencyAssigned which identifies all the agencies assigned to a Report in table ReportID. Each ReportID may have many Agencies, and the query reflects this Is it possible to Concatenate all of the agency values into a single text box control source on a form or to do...

Again thank you for sharing you knowledge, it worked very good Thanks Ron

Sorry arnelgp I cant quite understand step 1 I have done as advised above can you check if I have understood this correctly I entered the code and it works when I enter Homecare but not any of the other values. If the user selects DoH it would need to populate with Mobilty etc. If I do it...