expression in form

  • Thread starter Thread starter darren
  • Start date Start date
D

darren

I am using Access 2007

I have an expression (IIF statement) as a control source in a form that is
dependant on the data entered in an unbound text box in the same form. The
problem is when data is entered into the text box, the expression does not
automatically calculate. I have used a refresh button to overcome the problem
though am not satisfied with this.
 
If the textbox determines the control source try something like this:

On the AfterUpdate of the text box:

If not isnull(me![TextBoxName]) then
[ControlName].ControlSource = me![TextBoxName]
me![ControName].Requery
end if

On the OnCurrent of the form:

If not isnull(me![TextBoxName]) then
[ControlName].ControlSource = me![TextBoxName] (or whatever you want)
end if

If this isn't what you are trying to achieve please let me know with an
explanation of what you are.
--
<a
href="http://www.software-matters.co.uk/bespoke-database-design.html">Bespoke
Access Database Development</a>
<p>Software Matters</br>
Straightforward solutions that work</p>
 
It looks like softwarematters is trying to change the control source for the
target control.

I think that darren had a calculation there that would calculate a value in
an unbound control (with iif(...........).

In that case all he needs is the me![controlname].requery in the
afterupdate event of the other textbox
 
Back
Top