J
JoeA2006
I currently have a form that allows the user to mark a record as inactive. I
am loading the field using the Now() function
Private Sub MarkAsDeleted_AfterUpdate()
Me.DateDeleted.Value = Now()
End Sub
I compare that to the begining date of the reporting month to determine if
that record should appear in reports going forward.
What I actually need to do is use a period deleted field to compare to the
report period. I need to load the report period number which I have in a
table into the query.
I tried
Me.PeriodDeleted.Value = [qrySelectTransactions.PeriodNum]
Since this does not work, is it possible to reference a form field or query
field to load into another query either using VBA or query designer?
am loading the field using the Now() function
Private Sub MarkAsDeleted_AfterUpdate()
Me.DateDeleted.Value = Now()
End Sub
I compare that to the begining date of the reporting month to determine if
that record should appear in reports going forward.
What I actually need to do is use a period deleted field to compare to the
report period. I need to load the report period number which I have in a
table into the query.
I tried
Me.PeriodDeleted.Value = [qrySelectTransactions.PeriodNum]
Since this does not work, is it possible to reference a form field or query
field to load into another query either using VBA or query designer?