Web Database Combo Box Macro

[ccondran08]

Hi, just wondering if anyone can help here. I have set up a new web database that will eventually be uploaded to sharepoint 2010 and i'm trying to find some help in getting a combo box on my navigation form (Horizontal Tabs - 2 Levels) to filter the data. I am very new to web databases and macros but have been using VBA for the past 3 years without any problems. The closest thing i have found is in the Price Comparison sample template of Access 2010 (File - New - Web - Price Comparison).

If you look at the 'Track Prices' tab you can see the Product and Store combo box which is driven by the 'macTrackPrices' macro. The combo box is named Product and the word Product is mentioned 5 times in the macro. Can some one please assist me here to decode the macro so i can change the combo box to cbo_Product and make the macro work, then i can translate the coding to my web database. The Macro is ;

If Not (IsNull([Product])) Then
SetTempVar (Product,[Product])
SetFilter ([Product]=[TempVars]![Product], DS]

If someone can please tell me where the 'cbo_Product' should go then that would be great. Also, what does the 'DS' refer to in the formula. I cant seem to find anything in the form that is called DS and will more than likely need to reference this in my database??

Thanks in advance.

:banghead:

 

[ccondran08]

In case anyone is interested I've solved this with a bit of probability modelling. There was 32 possible combinations that Product could have been replaced by cbo_Product in the macro below. So one by one I went through all the possible combinations and hit success on the 5th combination. I have changed the first 2 lines below and it works fine.



If Not (IsNull([cbo_Product])) Then
SetTempVar (Product,[cbo_Product])
SetFilter ([Product]=[TempVars]![Product], DS]