multi-value lookup fields display all values

[tjones]

Is it possible to create a field on a form that allows the display of all values set?

I created a field "Course" that has the values "CRNO, Section, Name, Unit" pulled from table Course.

When I use a combo box all four sections show up when the arrow is selected but upon selection of the course you want, only the first "CRNO" is displayed in the one section box.

View attachment 40681

The bottom one is how I would like the resulting field to look.

 

[pbaldy]

The only way you can get exactly that look is to create a concatenated field in your source query (ie a single field with all 4 values in it) and display that. A combo will only show a single field once a selection is made. Here's an alternative, using in your case 3 extra textboxes:

http://www.baldyweb.com/Autofill.htm

 

[tjones]

I read that eariler when I was looking for a solution but still do not understand (sorry 1st time user here).

What I originally wanted was to enter a value in Course number and have the other's fill but could not get that to work either.

Right now the form is set up will all four as seperate fields.

 

[pbaldy]

I don't know what "could not get that to work" means. Error, wrong result, ??

 

[tjones]

Sorry for the poor wording. Basically I had CRNO as a drop field, and wanted the others to fill.

I did not get any error msg or such, nothing I tried made them fill. My take is that I was not even close to doing it right. Guess I have no idea on how to set the fields up do do this ie combo, text or any of the macro, vb would be needed.

 

[pbaldy]

Did you try either of the methods in the link? Let's see what you've tried and fix it.

 

[tjones]

Yes I tried, but I do not think I have my fields set right. First I tried as textbox, then as combo box (drop list type). I really did not even understand what I was supposed to do.

Here is the original (graphic) What I want is to have
Class No as a drop list, when you make that selection, the Class Name, Section No, and Unit fields fill so you do not have to enter the information.

View attachment 40684

I have a table called Courses with the information entered for these fields.

 

[pbaldy]

Did you get this sorted out? I get an invalid link error trying to download the attachment.

 

[tjones]

I did. I tried sending you a note but it would not let me. Thanks for all your help.

 

[pbaldy]

No problem, glad you got it working.