Can anyone tell me why the following bit of code doesn't work
If IsNull(Me.Parameter_form.Value) Then
Me.Parameter_based.Value = "No"
ElseIf Me.Parameter_form.Value <> Null Then
Me.Parameter_based = "Yes"
"Parameter_form" is a combo box and "Parameter_based" is text box
This bit of code is attached to the form close button, but it never updates the text box. Is this because the if statement is looking at a combo box and you have to treat them differently and if so how do I evaluate the value?
Thanks very much for that it seems to work now but with one problem..........................it only updates the last entry that has been entered or amended. All the other records on the form are unchanged. As this is a continuous form the records will be entered more than one at a time.
Calls to an object on a continious form will only affect the object for the currently selected record. If you wish to alter the ENTIRE recordset, you would be better advised to run an UPDATE statement and requery the form.