Two forms, first to show if value = A, and second to show if value = B

[mflower]

Anyone knows the procedure I can write based on this logic:

I have two forms: Form1 and Form2. And two types of members: A and B. If member = A, then Form1.show, if member = B, then Form2.show..
I have problem in declaring the variables and writing the full code...please help..thanks

 

[JoeMiller]

This code will work if member can on be "A" or "B", if it can be another value than we need to use a select case statement.

[tt]
If member = "A" then
DoCmd.OpenForm "FormNameWhenValueEqualsA"
Else
DoCmd.OpenForm "FormNameWhenValueEqualsB"
End if
[/tt]

HTH


Joe Miller
joe.miller@flotech.net