Good Evening all,
I'm facing a strange situation... I have a Form that opens and allow user to select some products. Then when they're finished, they close it and another form shows the request header and the selection. The problem is that the list of chosen items on this second form is always, one item less than the suppose.
If I requery again or close and open the form it shows all the selected items...
My code:
I have some trigger on the first form closure that requery the second one...
Private Sub Form_Close()
If Me![FormRequisitionBody].Form.Dirty Then
Forms.RequisitionBaseReq.FormRequisitionBodyviewonly.Requery
Forms.RequisitionBaseReq.FormRequisitionBodyviewonly.Form.Dirty = True
End If
End Sub
What am i doing wrong?
Ps.: I'm a newbie on access, but i'm focus on improovement.
Thank you,
Best regards,
João Santos
I'm facing a strange situation... I have a Form that opens and allow user to select some products. Then when they're finished, they close it and another form shows the request header and the selection. The problem is that the list of chosen items on this second form is always, one item less than the suppose.
If I requery again or close and open the form it shows all the selected items...
My code:
I have some trigger on the first form closure that requery the second one...
Private Sub Form_Close()
If Me![FormRequisitionBody].Form.Dirty Then
Forms.RequisitionBaseReq.FormRequisitionBodyviewonly.Requery
Forms.RequisitionBaseReq.FormRequisitionBodyviewonly.Form.Dirty = True
End If
End Sub
What am i doing wrong?
Ps.: I'm a newbie on access, but i'm focus on improovement.
Thank you,
Best regards,
João Santos