Hello,
I need some help on getting an IF-Then Statement to work. This is working off the OnChange in a Combo box. The user picks a company from the drop down list & I want the facilities table associated with this company to open. Here's my test code:
If Fac_tab = "BADGER" Then
DoCmd.OpenTable "BADGER_FAC", acViewNormal, acEdit
Else
If Fac_tab = "BB&W" Then
DoCmd.OpenTable "BBW_FAC", acViewNormal, acEdit
End If
End If
I also tried using Case, but no luck there either. Any help would be appreciated.
Thanks in advance.
I need some help on getting an IF-Then Statement to work. This is working off the OnChange in a Combo box. The user picks a company from the drop down list & I want the facilities table associated with this company to open. Here's my test code:
If Fac_tab = "BADGER" Then
DoCmd.OpenTable "BADGER_FAC", acViewNormal, acEdit
Else
If Fac_tab = "BB&W" Then
DoCmd.OpenTable "BBW_FAC", acViewNormal, acEdit
End If
End If
I also tried using Case, but no luck there either. Any help would be appreciated.
Thanks in advance.