ComboBox

davies107

Registered User.
Local time
Today, 15:48
Joined
Oct 2, 2012
Messages
143
hello everyone,

im having a problem with my combobox. i tried everything but it seems that i could not find the solution.

attached is the photo to explain everything. i have 1 combobox with 5 records in it (Class 1 - Class 5). Whenever a user click a specific Class number the 3 boxes below (Estimation Class Description, Expected Accuracy Low Range, Expected Accuracy High Range) should be filled with its corresponding information.

Note: this is not the main form, its just part of the main form. actually, its just a box.

can anyone help me with my problem, im stuck with this, sigh.
Thanks!
 

Attachments

  • ComboBox.jpg
    ComboBox.jpg
    17 KB · Views: 83
Typically the information you want to appear in your text boxes would form part of the row source of your Combo.

You would then use the following schema to fill those boxes;
Code:
=YourComboName.Column([B][COLOR="Red"]x[/COLOR][/B])

Where x represents the column that hold the data you wish to appear in that text box.

Here's a small sample that demonstrates the principal.
 

Attachments

Hello John,

will try this sample DBS of yours. Thanks a lot!
 
hello John,

i followed everything BUT theres a problem in your sample. eveyrthing is in a form while mine is just inside a box. attached photos are provided to make it more clear. im having a problem where to put the TABLE as my row source, take note mine is just a box (inside a form) not a form itself.

Thanks.
 

Attachments

  • Box574 - 2.jpg
    Box574 - 2.jpg
    75.1 KB · Views: 75
  • Box574.jpg
    Box574.jpg
    77.8 KB · Views: 74
the main form has a different row source, thats why i dont know what to do that the box should have a separate/different row source from the main form.
 

Users who are viewing this thread

Back
Top Bottom