hi guys, new situationfor this forum......
I have 2 forms(addponumber/sure) and a subform(ponumber subform).
addponumber: It has the ponumber subform and an exit button.
ponumber subform: it has a list of records (continuous. form) coming from a
query. It shows 4 locked fields, 1 unlocked field with an
after_update code and also has a non visible field called
vsure.
After_update code
sure: This form was made to comfirm any modification. It has 2 buttons
(Yes/No). Here is the code for this form:
So, i open the addponumber form and modify the unlocked field in ponumber subform. Once i move to another record, the after_update code is triggered and the sure form is opened.
The problem is that once i press Yes or No (no matter which one) i receive an error..."the referred form ponumbersubform is not found or valid"
it thinks that ponumber subform is a form when is a SUBform.
I am calling the sure form from other forms without any problem, except for this one.
why is not working properly?
thx, max.
I have 2 forms(addponumber/sure) and a subform(ponumber subform).
addponumber: It has the ponumber subform and an exit button.
ponumber subform: it has a list of records (continuous. form) coming from a
query. It shows 4 locked fields, 1 unlocked field with an
after_update code and also has a non visible field called
vsure.
After_update code
Code:
DoCmd.OpenForm "sure", , , , , acDialog, Me.Name & ";vsure"
If Me.vsure <> 1 Then
Me.ponumber = Me.ponumber.OldValue
End If
sure: This form was made to comfirm any modification. It has 2 buttons
(Yes/No). Here is the code for this form:
Code:
DoCmd.OpenForm "sure", , , , , acDialog, Me.Name & ";vsure"
If Me.vsure <> 1 Then
Me.ponumber = Me.ponumber.OldValue
End If
So, i open the addponumber form and modify the unlocked field in ponumber subform. Once i move to another record, the after_update code is triggered and the sure form is opened.
The problem is that once i press Yes or No (no matter which one) i receive an error..."the referred form ponumbersubform is not found or valid"
it thinks that ponumber subform is a form when is a SUBform.
I am calling the sure form from other forms without any problem, except for this one.
why is not working properly?
thx, max.