It is better to use property get and let to create custom properties so you can control the setting and getting of the value.
e.g. Create a custon property for a form, call it frm_Id:
Code:Private frm_id As Long Public Property Get Id() As Long Id = frm_id End Property Public Property Let Id(SubmitId As Long) frm_id = SubmitId End Property




Reply With Quote