How to change Row Source

[Jamie2002]

I'm trying to write code to change the row source of a list box.

On another thread is shows that the SELECT statement needs to be enclosed in " ".

Half way along the code is a format(field1, "#,##&quot, I am getting an error because access expects the code to end after the first " in the format expression. Is there any way around this or will I have to make 3 queries based on the different option selected and then do rowsource = "Query1" , "Query2" etc.

Thanks.

Jamie. Thanks

Jamie

 

[JJOHNS]

Try using single quotes in your format function:


format(field1, '#,##')


If that doesn't work, I'd try this:

format(field1, '" & #,## & "')

 

[Jamie2002]

Single quotes it is......Thanks. Thanks

Jamie