combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I have a student form with a subform to record the status of student i.e.
accepted or refused so in the subform is the status id from the many table
and it is a combo box. I have the status description from the status table
and when the status id is selected the status description gets filled in
automatically. How can i make it that they don't see complicated id's and
just the description field?
 
If you set the width property of the first column (I assume you have the ID
in the first column) to 0, it doesn't display. Actually, any column who's
width is 0 doesn't display in the combo box.

Good luck

Jeff Boyce
<Access MVP>
 
will that still fill through into the tables in the correct way i.e. the
status id will be the field that is filled through into the many table even
though the user will not be seeing that?
 
Read up on combo boxes and how they're used. If your "bound" column is the
RowID, that's what is stored.

Good luck

Jeff Boyce
<Access MVP>
 
The id column is the bound column but because i set it to naught there's no
column so in the underlying Status Given table in the status id field the
actual status description gets filled in and not just the plain ID. Is that
ok?
 
Not sure I'm following your description, but if your bound column has a
display width of zero/naught, that only means it doesn't show in the combo
box. Again, you may want to read up on combo boxes, how they work, and how
to use them, for a better understanding.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top