Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 5th, 2006, 08:08 AM
Registered User
 
Join Date: Jan 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to zuldan23
Default Auto-Filling a Text box based on Multiple Boxes

In one of my databases I have a combo box (cmb1) that selects values from a table (tbl2) and then saves that value into another table (tbl1). I also have a set of five check boxes (cbx1, cbx2, cbx3, cbx4, and cbx5). What I want to do is if a user puts in a certain set of information I want another text box (txb1) to autofill with a hyperlink to a word document.
For example if they select "RPMI" in cmb1 and then check cbx1 and cbx2 I txb1 to automatically fill in the hyperlink to a certain word doucment that describes their selection more fully.
I hope that this is clear and that I can get some help. Also I am not much of a programmer at all so I kind of need it laid out. Thanks.

 
Old May 5th, 2006, 10:17 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Well, it can be done, but how many documents do you want to link them to? How many possible combinations of 5 check boxes (120 combinations) times the combo box list? Where are you going to put the code (what event?)

There are so many possible combinations here that I am not sure how to code this. Please let me know how many possible combinations of combo box selection with check boxes there are, plus the number of word docs there are links to. It can be done, it will be a lot of code I think.

HTH


mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
drag and drop to multiple text boxes gbuller VB.NET 5 September 6th, 2004 09:55 PM
Multiple records to be put in text boxes Moumou Classic ASP Databases 3 September 3rd, 2004 06:33 PM
Auto update of text box/label Simon Dilley Classic ASP Basics 1 June 6th, 2003 07:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.