Form Design

[khiemadong]

Plz show me if you can.
i need to create a form with 1 combo box and 2 text box. when you click on the combo box drop down list, you would see it listed 3 attribute which is artist name, title, and copy. If you pick any of those selection, only the name would appear on the combo box, and the corresponding title and copy of them would display on the other two text box. One more thing that it need to be display on the continuous form.

I tried to do that already, but whenever i pick any selection, all of the below combo box would display the same value as the one i just pick. It does not display each individual one on each different combo box. Moreover, it sometimes even change the value of the table field when i pick a selection
Thank you very much for you help

 

[verplexd]

Are the three values that are in the combo box stored in a table, or are you using VBA?

 

[khiemadong]

those value is stored from either a table or a query. I'm not using VBA though
Thanks

 

[jbehrne]

Okay,

Make a bound form that displays the three values. Make an unbound combobox that references your table/query. It should pull up all three values artistname, title, and copy - w/ artist name as the one being shown. Now in the combobox's after update event do this:

Me!ArtistName = Me!ComboboxName
Me!Title = Me![ComboboxName].column(1)
Me!Copy = [ComboboxName].column(2)

If you need more detailed instructions let me know...


If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

 

[jbehrne]

Sorry,

that last line should look like this:

Me!Copy = Me![ComboboxName].column(2)

If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

 

[khiemadong]

it is still not working. I got those three values under the combo box, and change the form view to continuous view. Whenever i pick a selection, that same selection would display at every other below combo box. One more thing, the table data changed after i keep picking selection. For example,
Artist Name: Picasso, Juan, Dennis
Title : Poster 14 for Picasso, Awaken Child for Juan, and Rhythm for Dennis
Copy : 4/555 for Picasso, 3/222 for Juan, and 4/333 for Dennis

i suppose to create a form which have 3 or 4 combo box, and in there i am able to select each value corresponding to those fields. I did that but whenever i select anything, that same thing would display at theother combo box.
p.s if somebody have some spare time, please please let me send you the file so you can take a look at. i feel so frustrated over this right now. Thank you very much for ur kindness.