Have a textbox appear based on Combobox selection

[Ohaderfe]

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!

[MikeTheBike]

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

[missinglinq]

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)>