Locopete99
Registered User.
- Local time
- Today, 11:33
- Joined
- Jul 11, 2016
- Messages
- 163
Hi,
Can you help.
I'm trying to open one of two forms based on if a record exists in a table.
Can someone look at the code below and see where its gone wrong. the code doesn't do anything.
Can you help.
I'm trying to open one of two forms based on if a record exists in a table.
Can someone look at the code below and see where its gone wrong. the code doesn't do anything.
Code:
If DCount("Holon", "tbl_Holonsecurity", "[User]=" & fOSUserName()) > 0 Then
DoCmd.OpenForm "Frm_HlMain", acNormal
Else
DoCmd.OpenForm "Frm_Main", acNormal