If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > Access "Web Database" Cascading Comboboxes..... is dead

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jan 2013
Posts: 2
Access "Web Database" Cascading Comboboxes..... is dead

Hey guys noob here, but thanks for listening.

So basically I'm making a new software database in access 2010 but I'm doing it in the web database and not the traditional Access DB, and I feel like they chopped off my arms.

I'm trying to get some cascading combo boxes going but when I click on the "After Update" event in the properties tab it will only let me create a Macro, I only know how to create a cascading drop box in code. Also when click on the "Row Source" it takes me to a very limited query design.... but I figured out a work around that.

Anywho if anyone knows how to create a cascading drop box an access web database, that would be amazing.

-Mike

Just to clarify;

I'm trying to do Developer drop down box, which will then produce a list of software by that developer to choose, and then will produce a drop down list of the versions available for that software
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jan 2013
Posts: 2
And I just realized my work around mentioned above doesn't work. So here's my situation;

I've got a Table of software, it has three main fields "Developer" "Software" and "Version"

The developer and Software have several repeats I would like not to appear, example:

Adobe PhotoShop CS6
Adobe PhotoShop CS5.5
Microsoft Project 2010
Microsoft Visio 2010
Microsoft Visio 2007

So what I would like to do is create a form that has three cascading drop down boxes based off of the three aforementioned fields, which will then fill in another table that will keep a record of who when where and what.

But right now I'm focusing on the cascading part.

1 I can't get it to not repeat, ie. when you click on the drop down menu I'd like Adobe and Microsoft to appear once. I cannot find the "Unique Value" property to save my life right now.

2 I'm doing this is Access web database which seems to severly limit my motions and only lets me do macro.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On