IsNull Not IsNull expression/value not working properly

[cp1981]

Greetings!



I copied/pasted from one of the MS Access template DB's (Asset tracking) macro to Open two separate forms depending on whether there is an [ID] or not. A "New Account" form if not (Null) and "Account Details" for the opposite. Heres my issue: Where the macro is supposed to Open the New Account form, it opens up a blank Account Details form. I've tried my newbie novice knowledge on changing the OpenForm amongst others, but no joy. So, within this macro will be three forms: "frmAccountList" (Where the magic begins; With the user clicking on "Open" where the form "frmAccountDetails" opens or with the user clicking on "New" where the form "frmNewAccount" opens.

[moke123]

Be much easier in VBA

If Me.NewRecord Then
        ' open the form to a new record
    Else
        ' open the form to the specified accountID
    End If

[davegri]

I copied/pasted from one of the MS Access template DB's (Asset tracking) macro to Open two separate forms depending on whether there is an [ID] or not.

If you want to stick with macros, have another look at the asset tracking template. There are 2 on-click events calling separate macros, but both opening the same form. You apparently want to use 2 different forms.

One event is when "OPEN" (existing account) is clicked, opening Asset Details form with search criteria,

and the other macro for when "NEW" is clicked (opening same form in ADD mode).

You will need to modify just the latter macro to open your form that creates new accounts.

[cp1981]

Thank you so much to both of you guys for the help! I ended up going the VBA route. But regardless, both make sense! Again, thank you to both of you

[madpiet]

( Once you get your head around VBA and the Access object model, you can do some really crazy stuff with Access. Definitely worth the investment... Well, it was when I started many moon ago. Even if you just learn the basics)

[cp1981]

( Once you get your head around VBA and the Access object model, you can do some really crazy stuff with Access. Definitely worth the investment... Well, it was when I started many moon ago. Even if you just learn the basics)

When I was in the service, I did an instructor tour in San Antonio and within our schoolhouse we used Access for our student DB. Later on we got a guy that was FANTASTIC at Excel. He and I ended up revamping the DB into excel. I learned quite a bit from him. Ive even made a few "DB"s myself from Excel. But I cant lie, there were MANY times I wished I knew my way around Access like I do with Excel. I even realized then I needed to know Access better. I'm really trying this time and have even bought a book The platform is OBVIOUSLY way better to work with than having to type up a mile long formula just to look up records and slowing the CPU in the process. Anyways, thank you for taking the time to give your $.02! I think Im just going to let Excel do what its truly meant for instead of trying to re-invent the wheel.