By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,282 Members | 1,774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,282 IT Pros & Developers. It's quick & easy.

Have a textbox appear based on Combobox selection

P: 1
Hi to everyone!
This is my first post here so please don't shout at me!
My question is the following:
I have a table in which there is a field named "Resolution".It's a combo box and has three values "A", "B" and "C" (Note that i entered the values.There isn't any table connected to this table with the above values in it).
When i choose "C",from the drop down menu, then i want a new field to come up with new values in it.
Example:
Field:
Good Movie? "Yes" , "No"
When i choose "No" i want a new field to appear, for example:
Why Not ? "Bad Screenplay" , "Bad Direction" ,etc!

Hope that you have understand what i want!
I don't know visual basic etc and i am newbie user in Access 2007 and in Access at all!

Thanks in advance!
Aug 7 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 635
Hi
Hi to everyone!
This is my first post here so please don't shout at me!
My question is the following:
I have a table in which there is a field named "Resolution".It's a combo box and has three values "A", "B" and "C" (Note that i entered the values.There isn't any table connected to this table with the above values in it).
When i choose "C",from the drop down menu, then i want a new field to come up with new values in it.
Example:
Field:
Good Movie? "Yes" , "No"
When i choose "No" i want a new field to appear, for example:
Why Not ? "Bad Screenplay" , "Bad Direction" ,etc!

Hope that you have understand what i want!
I don't know visual basic etc and i am newbie user in Access 2007 and in Access at all!

Thanks in advance!
This is not, necessarily, a simple question!

If the combo box (with a value list) is in the table (in datasheet view), then as far as I know, there is no way to do anything when data is entered as there are no events available to look at what is happening.

This would/should all be done on a form. If there is a possibility that you want to use the 3 'Resolutions' (A,B & C) again somewhere else then I would put them in a little table (with an ID field), and use that for the source of the combo box with the ID being the stored value. The same comment would also apply to "Bad Screenplay" , "Bad Direction" ,etc. if they are to entered into a table.


MTB
Aug 7 '07 #2

missinglinq
Expert 2.5K+
P: 3,532
I think we need to establish for certain that this combobox is, in fact, on a table and not on a form. Newbies, especially, tend to get these two things mixed up. If, in fact, it is on a table, this needs to be changed, as Mike suggested. Data should never be entered directly into a table by users; this is a recipe form diaster. You don't have to do anything more complicated that goto Forms on the Objects Dialog box and click on "Create Form by using Wizard" and follow the instructions. Choose "Tabular" as the layout if you want you form to look like the table. Post back and let us know whether the combobox is on a table or form.

Also, the title for this post gives absolutely no clue as to the content of the post. I'll be changing it to something more meaningful. Since you are new to the forum, please take the time to read POSTING GUIDELINES at http://www.thescripts.com/forum/thread559246.html Paying particular attention to the section titled Give a clear title to your question.

Welcome to TheScripts, Ohaderfe!

Linq ;0)>
Aug 7 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.