Locopete99
Registered User.
- Local time
- Today, 07:03
- Joined
- Jul 11, 2016
- Messages
- 163
Hi Guys,
I have a form that I want to open, but there are 2 conditions.
1. If a record with the same record in the field Subba exists, then open that record.
2. If the record doesn't exist, open the form and auto populate the records with e record set.
I can do all of this, but stuck on the open if. My try was to have the following on an On Open.
Can someone help point me in the right direction.
Thanks
I have a form that I want to open, but there are 2 conditions.
1. If a record with the same record in the field Subba exists, then open that record.
2. If the record doesn't exist, open the form and auto populate the records with e record set.
I can do all of this, but stuck on the open if. My try was to have the following on an On Open.
Code:
IF "[Subba3]=" & "'" & [Subba] & "'" Then
DoCmd.OpenForm "Frm_Over", acNormal, , "[Subba3]=" & "'" & [Subba] & "'"
Else
**Do the record set**
End If
Can someone help point me in the right direction.
Thanks