Access Services db - Data/Named Macro Question

I'm an old hand at VBA and SQL but new to data macros. I have an Access 2010 web database with two tables, tblA and tblB, and two web forms, frmA and frmB.

On double click of a field in frmA I want to set a TempVar and use that to look up a record in tblA. If a record is found I want to navigate to form B (recsrc = tblA) and display that record, and if no record is found I want to navigate to frmB, create a record, and populate its fields with values looked up in tblB.

Do I use Look Up A Record In tblA to see if there is a record? How do I test to see if a record is found? Do I then use BrowseTo to navigate to frmB? If so, if there is a record do I display it by filtering on it in the form?

If somebody could outline the approach to take I'd appreciate it. In the client version of this functionality I had this working in 10 minutes with VBA and SQL. As it is, with Named macros I have spent two days running into one dead end after another.
dgmoore1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tony HungateTechnical Writer/Trainer | CISSPCommented:
You can still use most of your normal tricks seeing as you have experience with VBA.  You just have to change where some thing are placed and the syntax is predetermined and limited.

Have a loot at this and see if it helps.

Access Blog - Meet the Access 2010 Macro designer.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you working with a Web database?
dgmoore1Author Commented:
The question is not so much about macro syntax as it is about logic, how the methods work, and which ones to use. For example, if I apply Look Up a Record In TableName, how do I test for a null result?The documentation I've seen is not very extensive or detailed.
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

dgmoore1Author Commented:
LSM - yes, this is a hybrid Access 2010/SP2010 db. I'm trying to emulate the functionality in the client forms in web forms. Things that are easy in client forms will only become easy in web forms after I have figured out which methods to use to achieve my aim, and how to apply them. For example, in VBA/SQL I can use If rst.recordcount = 0, or If rst.EOF, to determine if no records are returned by a query. In a macro, how do I determine if no records are returned by the Look Up a Record in TableX:? If an error condition is raised, how do I determine what it is? Etc, etc... My problem is that things that are simple in vba/sql are not so simple in web macros.
Rey Obrero (Capricorn1)Commented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Unfortunately I haven't done much with Access web databases, and I've not yet run across a simple "cross reference" type of listing, where I could look at a VBA action and find it's equivalent Data Macro action. There are some MSDN articles out on the subject (see cap's links, and search "msdn ms access web data macros" for more of them).

This blog post intrigued me when I saw it:

http://blogs.office.com/b/microsoft-access/archive/2010/08/24/going-beyond-web-macros-using-event-receivers-amp-net-with-access-services.aspx

It refers to using .NET to build event handlers for your Access web databases. Of course, if you're going to that trouble then you might just move to ASP.NET anyway and be done with it!
dgmoore1Author Commented:
Useful links to further information which I'll be referring to in the future. I found a direct answer to my question on UtterAccess.com, however. Thanks to all.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.