richard terry wrote:
..
> sql = sql & address.preferred_address & ", "
> sql = sql & address.postal_address & ", "
..
> Insert into data_addresses (street, fk_town, postal_address,
> preferred,head_office) VALUES("1 Any Street",922,T,T, , 1)
>
> Note the section here ************T,T, , *******************
..

to use T & F must use '. I think something like this might do:

sql = sql & "'" & address.preferred_address & "'" & ", "
sql = sql & "'" & address.postal_address & "'" & ", "


--

regards, jr. (jr@tailorware.org.uk)