M
mjj4golf
I want to clear a rcord from a form. I open the table and then do the code
below(snippet):
DoCmd.FindRecord forms!frmname.[ID}
Me.AllowEdits = True 'Edit Record
Me!ID.Enabled = 0
rstRC_Main.Edit
nam = rstRC_Main![Last Name]
rstRC_Main![Last Name] = Null
the findrecord gives me a msg saying it is not available now.
Can someone explain.
Mike
below(snippet):
DoCmd.FindRecord forms!frmname.[ID}
Me.AllowEdits = True 'Edit Record
Me!ID.Enabled = 0
rstRC_Main.Edit
nam = rstRC_Main![Last Name]
rstRC_Main![Last Name] = Null
the findrecord gives me a msg saying it is not available now.
Can someone explain.
Mike