Put Multiple value in one text box with click from combobox

[ZKHADI]

hy buddies!

for example a student have multiple subjects.
i have one text box and on click even on combobox can I put multiple subjects in one text box.
kindly check image.

for example : Biology, Chemistry, Physics

 

[Minty]

The subjects should be stored in a separate child table.

You can then collate the results into a control for viewing purposes., using something like http://www.accessmvp.com/thedbguy/codes.php?title=simplecsv

 

[arnelgp]

use separate table as suggested.
and use Subform for the subjects.

 

[Gasman]

O/P has already been advised this once.

Multiple select combobox Subject add to a textbox

hy buddies: i have a form with multiple subject combobox. the problem is that the combobox selected subjects are not putting in textbox. if select one subject then it updated in textbox but if select more than 1 the old 1 subject also disappear. i coded the combobox on click even as shown in...

www.access-programmers.co.uk

 

[GPGeorge]

Sometimes we need to hear good advice more than once to appreciate that it is, in fact, good advice.

You can DISPLAY concatenated values in an unbound text box control if you want, but storing that in a field in a table is going to become an albatross around the neck of your users.

 

[Pat Hartman]

@ZKHADI Do not allow your presentation requirements to dictate how you actually store data. If you store the data correctly using a table, you would use a subform to collect the information.

 

[ZKHADI]

Sometimes we need to hear good advice more than once to appreciate that it is, in fact, good advice.

You can DISPLAY concatenated values in an unbound text box control if you want, but storing that in a field in a table is going to become an albatross around the neck of your users.

i will try this method