Two Combo Boxes Walk into a Bar, and want to open a file.

[Fordrax]

Afternoon,

I am new at the database, I dabbled around with buttons and have a hang of that, but want to do something for the different years that users can use a combo box to drop down which year, then will pop up with another combo box for them to select which community then open a folder on the drive pertaining to that community by using application.hyperlink, there will be more info but I am stuck at this simple part.

I know the question is going to be asked 'we have that already just open the file browser' but this is going to be only a third of what else is going to be on this database.

Thanks in advance.

[pbaldy]

I'm not clear on where you're stuck. The combos sound like they'd use this:

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

Presuming one or both of them contain path info, they could be used with FollowHyperlink.