Search results

I have an existing access database w/userform. one of the controls (textbox) has its control source formatted as such: =[table1] & Right(Year([table2]),2) & [table3] how would i implement a similar statement in VBA, say to assign this to a string variable?