469,609 Members | 1,414 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

Edit format of field in a form that can be populated by a lookup

It would be great if someone can help me with this. It seems like it
should either be easy (so far, not!) or maybe it isn't possible. Here
goes:

Table B has TextField1 that looks up values from a single field in
Table A. When I create a form for filling in Table B, TextField1
appears as a long list of options from Table A. If I were to make the
field really tall, it would show multiple rows of data from Table A.

I would prefer that it look more like the version of TextField1 in the
actual table of Table B, where a drop down becomes visible when I click
on the field but is hidden once I've made a selection.

Easy? Imossible? Somewhere in between?

Many thanks,
JS

Dec 8 '05 #1
3 1578
You can use a ComboBox/Drop-Down List to accomplish this. You'll set
the RecordSource property of your ComboBox to an SQL statement or query
that looks up the values in Table A.

Dec 8 '05 #2
You can make the field appear as a combo box by going to the 'lookup' tab on
the form design window and setting 'display control' as combo box.
While I'm telling you this, I should also tell you that this feature of
Access, while it can by handy, can also cause you problems down the road as
you create applications.As you gain more experience in Access, you will
probably want to avoid having lookup fields in the tables themselves and put
combo boxes in forms rather than in the tables. Here is some info if you
care to study this more. You can also safely ignore this stuff and your
project will probably work fine.

http://www.mvps.org/access/lookupfields.htm

http://groups.google.com/group/micro...f4e54e5ab24e00

"silvastein" <je******@seattleparksfoundation.org> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
It would be great if someone can help me with this. It seems like it
should either be easy (so far, not!) or maybe it isn't possible. Here
goes:

Table B has TextField1 that looks up values from a single field in
Table A. When I create a form for filling in Table B, TextField1
appears as a long list of options from Table A. If I were to make the
field really tall, it would show multiple rows of data from Table A.

I would prefer that it look more like the version of TextField1 in the
actual table of Table B, where a drop down becomes visible when I click
on the field but is hidden once I've made a selection.

Easy? Imossible? Somewhere in between?

Many thanks,
JS

Dec 8 '05 #3
It was simple! Feeling silly for not figuring it out. Thank you both
-- I really appreciate the db design advice re: when to use lookups.

-JS

Dec 8 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Jim | last post: by
1 post views Thread by Svelte Poshy | last post: by
1 post views Thread by Old Timer | last post: by
3 posts views Thread by Damon Grieves | last post: by
reply views Thread by Solution2021 | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.