I can usually find my answers by googling, or checking this forum, but for some reason this one eludes me.
I am trying to check one table using the Dfirst domain aggregate, and copy that value (Date) to a second table in a new record. The new table is nothing more than a checklist that tells me if that date has been processed. I can not change the original table to do this, and my ultimate goal is to use the checklist to control aspects of a form. Basically I can't figure out how to reference the new table/record/field to PASTE the date in to. The rest of it I have pretty much figured out. Here's my completely non-working code, but at least it will give you an idea:
Private Sub Append_D2A_Click()
On Error GoTo Err_Append_D2A_Click
Dim stDocName As String
Dim Store_Date As Date
Dim rst As Recordset
Set rst = CurrentDb().OpenRecordset("Archived_Bit")
' stDocName = "Append Daily to Linked Archive"
' DoCmd.OpenQuery stDocName, acNormal, acEdit
Store_Date = DFirst("Date", "tbl_Inventory")
rst.Fields(1) = Store_Date
I know I have to get the record moved to the end of the table before I add, but so far my code does not get past the "Set rst" line.
Thanks for any help!