I spent all weekend working on this and got absolutely no where.
I have a database with an input form that runs an append query to append to a table.
Form Name: Poetry
Append Query Name: Created_Submitted_Work
Table Name: Created_Submitted
I have also created what I hope is an update query. The purpose of this query is to check whether a record exists that contains the words “Not Applicable” in the table field [Submitted To]. I am trying to test this in stages by verifying I can examine the table field for “Not Applicable” in the (Created_Submitted.[Submitted To]) field after clicking the Add Record command button.
I am constantly getting the message “Run-Time Error '424 - Object Required”. But I don’t know what it is referring to. I assume it is not able to access the table to verify the field contents. If that is the case I have no idea how to make it happen. If that is not the case, then again, I have no idea what is causing this.
I have commented out everything in the event and am just trying to do s simple if statement to see if it works.
Here is what I used to test that:
Expand|Select|Wrap|Line Numbers
- Private Sub CMD_AddRecord2_Click()
- If (Created_Submitted.[Submitted To]) = "Not Applicable" Then
- MsgBox "This Worked!", vbOK, "Woo Hoo!!!"
- End If
- End Sub