List Box not updating underlying table

  • Thread starter Thread starter Volta
  • Start date Start date
V

Volta

I have a form which should update a field on the underlying table using a
list box. The Row Source I am using for the form field is selecting a
single field from a second table which has no relationship to the first. I
have set the Control Source of the field to be the field from the underlying
table and I have set the Bound Column to 1 (since my select statement
involves a single column). The table is not being updated with the value
which is displayed in the list box on the form. Am I missing something
which is pertinent in tying the form field to the underlying table?
 
Never mind! I was tabbing past my list box if the appropriate choice was
displayed - but it hadn't been selected! I will have to figure out a way
to prevent my users from making the same assumption. I might change it to a
combo box so that the selection process cannot be inadvertently skipped...
 
You can default the value of the list box to the first item in the list...
where frmS is the name of your form and lstC is the name of your list box

=[Forms]![frmS]![lstC].[ItemData](0)

It will show up highlighted, but unless you make that field required, the
users will still be able to pass it by and you may get the wrong one, unless
you train them that they must choose a list item if the first is not what
they want.
 
Thank you - again - Mr. Linson! I really appreciate your time in replying.

Larry Linson said:
You can default the value of the list box to the first item in the list...
where frmS is the name of your form and lstC is the name of your list box

=[Forms]![frmS]![lstC].[ItemData](0)

It will show up highlighted, but unless you make that field required, the
users will still be able to pass it by and you may get the wrong one, unless
you train them that they must choose a list item if the first is not what
they want.


Volta said:
Never mind! I was tabbing past my list box if the appropriate choice was
displayed - but it hadn't been selected! I will have to figure out a way
to prevent my users from making the same assumption. I might change it
Click to expand...
to
a
combo box so that the selection process cannot be inadvertently skipped...
Click to expand...
using
a first.
I
Click to expand...
Click to expand...
 
Back
Top