send data from Combobox to columns at the same row

[VBA2020]

Hi
i have a problem with sending data from a ComboBox to 10 columns at the same row. every time of combobox selection
using a Button ,
any one can help plz.

 

[SkipVought]

Hi,

So if you select BANANA from this ComboBox you want that value to be placed into 10 columns of what row.

What kind of ComboBox: ActiveX, MS Forms, Data Validation?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[VBA2020]

no man different selections of control comboBox in a userform until columns from (B2:K2)
ok!
B2 Banana
C2 Apple
D2 Grape
.
.
.
K2 kouki

 

[SkipVought]

So the data will always be placed into row 2?

What happens when the 10 columns in row 2 are filled?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[VBA2020]

No it is a data base.man!
logically moves to new row with new data,

 

[SkipVought]

No it is a data base.man!

Well your problem has been that you have failed to clearly express your problem!

Now you have made clearer your intent.

Your data base is clearly not designed to best and accepted data base design practices, since you have an non-normalized structure where an entity (Medication) is repeated in any row. Briefly, I can cite two compelling reasons against this design: 1) a patient can have fewer or more than 10 meds in one visit, I would surmise, 2) when it comes to performing queries on this data, having multiple Med fiedsa will be a coding nightmare.

I strongly suggest a different db table design.



Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[VBA2020]

OK!
i have a questions plz.
did you have a complete conclusion about the idea.?
and what the ID in the 1st column refers to?
don't worry about the queries

 

[SkipVought]

What happens when the patient has eleven or twelve meds in a visit?

You stated, “don't worry about the queries“ but dollars to donuts, the question will be raised, about the number of meds and the frequency of each/any med use. Maybe not right away, but eventually someone will raise the question, and you will be asking how to make sense out of your design for the purpose of such a query, which will be made much more difficult with your “data base” design.

But lets say you go with the current design.

If you have fewer than 10, how do you indicate, I’m done?

If you have more than 10, how do you handle that?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[VBA2020]

Dear SkipVought
i am so happy to discus my problem with you
you let me closer for what i want, specially the last tow queries

If you have fewer than 10, how do you indicate, I’m done?
If you have more than 10, how do you handle that?

thank you

 

[SkipVought]

I’d be glad to hear your answers to these two questions.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]