Create a query that smooshes data into one field on a form?

[conneticat]

Not sure how to ask this...
Query or whatever that takes one field in all the records and outputs all that data into a single inline field (I'll worry about delineation later) on a FORM (not into a report...that would be too easy)

 

[PWise]

ON FORM OPEN
dim txt as string
DIM mydb as Database
dim rst as recordset
Set mydb = currentdb
Set rst = mydb.openrecordset("Select fieldname from table")
do while not rst.eof

txt = txt & rst(0) & ','
rst move.next
loop

me.txtsmooshes = txt

 

[PWise]

sorry
rst move.next
Should be

rst.movenext

 

[dhookom]

Did you check the forum FAQs first? This might be what you need faq701-4233

Duane
Hook'D on Access
MS Access MVP