Search results

DLookup() was just what i needed! Thanks

It would seem that the contents of the textbox is populated based on data from 3 tables. This string in the textbox's "Control Source" field: =[table1] & Right(Year([table2]),2) & [table3] seems to reference the required values from table1, table2 & table3. What I was wondering (and it...

no, they are access db tables. perhaps this is where the failing of my explanations lie...

http://msdn.microsoft.com/en-us/library/aa752041(VS.85).aspx

Yeah, I am aware of that. The control, which is a textbox, does not give me an option to access the text contained therein. I get "object requried" error when trying to access the "text" property txtmycontrol.Text generates the error. when referencing only the control name, as you...

i had tried that, but when used for example msgbox txtnameofcontrol i do not get the correct value (which should be a configuration string)....

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?