I am trying to retrieve some field information from the active record within a subform, and I am not able to.
I get the runtime error 424 "Object required". I have tried with getValue, without getValue, etc. but cannot get it right.
I have attached the code and design of the form.
Option Compare Database
Private Sub Command2_Click()
Set db = CurrentDb()
SubCurrent = Forms!DeleteRecord![Displa
' this next statement returns error.
txtID = Forms!DeleteRecord![Displa
StrSQL1 = "Delete MainTable.* from MainTable Where ItemID = " & txtID