All,
Syntax problem somewhere. Any help is appreciated.
In a button on the "Parent" form Macro I have the following, meant to open the "Child" Form to same record selected.
I have this working with using one criteria t find the Child record, but combining the 3 fields is giving me trouble.
The Child form opens but not to any specific records.
Something funky in the following:
="[Acct_Key]=" & [Acct_Key] & " AND [Sec_Key]=" & [Sec_Key] & " AND [Hold_Date]='" & [Hold_Date] & "'"
FYI - Acct_Key and Sec_Key are text fields. Hold_Date is a Date field
As always, Thanks
Syntax problem somewhere. Any help is appreciated.
In a button on the "Parent" form Macro I have the following, meant to open the "Child" Form to same record selected.
I have this working with using one criteria t find the Child record, but combining the 3 fields is giving me trouble.
The Child form opens but not to any specific records.
Something funky in the following:
="[Acct_Key]=" & [Acct_Key] & " AND [Sec_Key]=" & [Sec_Key] & " AND [Hold_Date]='" & [Hold_Date] & "'"
FYI - Acct_Key and Sec_Key are text fields. Hold_Date is a Date field
As always, Thanks