>I want a listbox's rowsource to be:
>
>formfield, LEFT(profiler,100)
>
>but it won't let me. It allows me to enter that value but when the form runs I receive a syntax error. I'm doing a sql select into a table but I don't want to do a sql select LEFT(profiler,100) because I need the entire field for other purposes and I want the fieldname to remain the same and not become exp_2, etc.
>
>Is it possible?
>
>TIA,
>Tracy

to avoid a renaming like 'exp_2' I do this...

SELECT LEFT(Profiler,100) AS MyNewName FROM Customer INTO CURSOR TestQuery

then the field is called MyNewName...

and I make the RowSourceType = 2
and RowSource = TestQuery