DRSinclair
Programmer
Hi,
I have a table containing various contact address, on a sales invoice document i have i would like to be able to append the value of a text control called BuCode onto a Select statement to return the correct contact name, i have tried this in the Finish and OnRow methods, but i get errors any ideas?
me.datavalue=SELECT CONTAC FROM ccCons WHERE Con_CODE='000000000' & (BuCode)
I have a table containing various contact address, on a sales invoice document i have i would like to be able to append the value of a text control called BuCode onto a Select statement to return the correct contact name, i have tried this in the Finish and OnRow methods, but i get errors any ideas?
me.datavalue=SELECT CONTAC FROM ccCons WHERE Con_CODE='000000000' & (BuCode)