How to make a value list's rowsource to reflect records in a coluimn

[Richard Hollenbeck]

I have a column in a table that currently only has one record. That column
is set to combo box. I want the user to be able to lookup values from the
column itself--the very same column--rather than a long list of values in
the rowsource. Then, if the value doesn't exist, the user could type it in,
and the next time that value is needed again it will be there in the list
without having to manually add that value to the rowsource. Is this
possible?

[Richard Hollenbeck]

That's okay, I just used the lookup wizard (for a change) and that set it up
for me. Thanks anyway.

Rich

"Richard Hollenbeck" <ri****************@verizon.net> wrote in message
news:8izog.6099$il.2861@trnddc03...

I have a column in a table that currently only has one record. That column
is set to combo box. I want the user to be able to lookup values from the
column itself--the very same column--rather than a long list of values in
the rowsource. Then, if the value doesn't exist, the user could type it
in, and the next time that value is needed again it will be there in the
list without having to manually add that value to the rowsource. Is this
possible?

[Allen Browne]

Try setting the RowSoruce to:
SELECT DISTINCT Col1
FROM Table1
WHERE Col1 Is Not Null
ORDER BY Col1;
where Col1 is the field the combo is bound to.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Richard Hollenbeck" <ri****************@verizon.net> wrote in message
news:8izog.6099$il.2861@trnddc03...

I have a column in a table that currently only has one record. That column
is set to combo box. I want the user to be able to lookup values from the
column itself--the very same column--rather than a long list of values in
the rowsource. Then, if the value doesn't exist, the user could type it
in, and the next time that value is needed again it will be there in the
list without having to manually add that value to the rowsource. Is this
possible?

[Larry Linson]

"Richard Hollenbeck" <ri****************@verizon.net> wrote in message
news:8izog.6099$il.2861@trnddc03...

I have a column in a table that currently only has one record. That column
is set to combo box. I want the user to be able to lookup values from the
column itself--the very same column--rather than a long list of values in
the rowsource. Then, if the value doesn't exist, the user could type it
in, and the next time that value is needed again it will be there in the
list without having to manually add that value to the rowsource. Is this
possible?

I also am not sure what you mean by "a long list of values in the
rowsource," as a Row Source should only contain values from which the user
should select.

It seems to me that you may be describing the case where the Row Source of a
Combo Box may well be a Query against the same Table to which the Combo Box
is bound, thus listing only the values already used for that Field, but not
_limiting_ the user... so the user can enter a new value, if needed. Such a
Query would have its Unique Values property set, so that any value would
only be listed once, no matter in how many records it actually appears. I
have often used this approach with good results.

Larry Linson
Microsoft Access MVP