Hi
I have a unbound textbox (unitsonhand) where the contents are calculated based on data in a subform, this works OK.
I have now added a textbox linked to a field in a table (discontinued). I have a form that displays records with these items on it.
I want to perform a check when each record is viewed thus: if unitsonhand <1 discontinued="yes" else discotinued="no"
As the unitsonhand is calculated the onchange event isn't triggered, any ideas on how to get around this.
Regards
I have a unbound textbox (unitsonhand) where the contents are calculated based on data in a subform, this works OK.
I have now added a textbox linked to a field in a table (discontinued). I have a form that displays records with these items on it.
I want to perform a check when each record is viewed thus: if unitsonhand <1 discontinued="yes" else discotinued="no"
As the unitsonhand is calculated the onchange event isn't triggered, any ideas on how to get around this.
Regards