By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,940 Members | 1,250 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,940 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.