Open Form From Form Where Criteria is Selected Bank

[burrina]

I have been implementing some new features to my db. I have a login form wher the user enters blah,blah, and it is from this form that I need to open another form with criteria in place. I get confused with this Where criteria code thing. Here is what I have;

LoginToCheckRegister Unbound (Form)
FReg Based on query QRegB (Form)

Query for Combo35 uses table TBanks to get bankid and Bank i.e. Name of Bank(s)
bankid
Bank


Need to open form FReg with criteria used from Combo25 on form LoginToCheckRegister
Whatever Bank I select from the combo, I then need to open form FReg with this criteria as the Bank being used.
Criteria is Bank that is the field name, control on the form FReg and in its table as well.
FReg forms table is TReg by the way.

[pbaldy]

Here's the syntax:

http://www.baldyweb.com/wherecondition.htm

[burrina]

So, to be clear, Don't see how this will work! It does NOT know what value I have in Combo35 ?

Here is my idea, will this work?

If IsNull Me.Combo35 Then
MsgBox "You Must Select a Bank From the List"
Else
DoCmd.OpenForm "FReg", , ,"[Bank] = Me.Combo35.Value"
End If

[ssanfu]

You are missing:
the open and close parenthesis for the IsNull function,
the correct field name (I think),
and an ampersand in the Where clause

If IsNull(Me.Combo35) Then
    MsgBox "You Must Select a Bank From the List"
Else
    DoCmd.OpenForm "FReg", , ,"[BankID] = " & Me.Combo35
End If

As long as the BankID is numeric (usually a Long), then this should work.