I have come across a way of making unbound controls take calculated values that are different for each record. In the datasource for the control type :
'=fnFunctionNam e(parameters)'
The fnFunctionName( ) would be a VBA function in the form module for instance.
Note: if you want the function to process values from other controls then simply place the names of these controls in the parameter list. I have found that accessing the other controls within the function code does not work. I think putting them in the parameter list informs Access what order to process the controls.
Enjoy.
Certainly makes life more easy.
ali
** Link removed ** by NeoPa (Admin).
'=fnFunctionNam e(parameters)'
The fnFunctionName( ) would be a VBA function in the form module for instance.
Note: if you want the function to process values from other controls then simply place the names of these controls in the parameter list. I have found that accessing the other controls within the function code does not work. I think putting them in the parameter list informs Access what order to process the controls.
Enjoy.
Certainly makes life more easy.
ali
** Link removed ** by NeoPa (Admin).