Jim Lawrence
accessd at shaw.ca
Thu Aug 31 11:36:07 CDT 2006
Arthur: The only way I would attempt to do this would be to create a form as a class and then I would be able to generate a new form depending on the results. This is more of a VB method but I think it should fully work in Access. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of artful at rogers.com Sent: Thursday, August 31, 2006 8:43 AM To: Access Developers discussion and problem solving Subject: [AccessD] Data-driven option buttons I think that I have asked this question before, but I can't find anything in my emails that pertains, so... Assume that a table T1 has several columns C1...C5, containing text, and another column containing an integer. (Let's sidestep the normalization issue, I am aware of that and trying to keep the example simple.) Here is the scenario: There is a Question column in T1, containing the text of a question to ask the user. The columns C1..C5 contain text representing possible answers to the question, from which the user can select exactly one answer. The integer column stores the number of the answer selected. For example: Q: On a scale of 1 to 5, do you consider yourself: a) a Genius b) quite smart but not a genius c) about average d) slower than most people I know e) smarter than a cucumber but it's close I would like the interface to present the question and then list its possible answers in the form of a set of option buttons, whose After-Update event will record the number of the option selected. This means that I must a) determine the number of possible answers; b) create that many option buttons (or alternatively create a maximum number and hide the irrelevant ones); and c) populate the labels for the buttons with the text stored in columns C1...C5. I can't figure out a cool way to do this. Any ideas, friends? TIA, Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com