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

Lookup in tables

hyperpau
Expert 100+
P: 184
calling in Neopa, and mmccarthy,

is it true that it is better to have the comboboxes created in the
design view of forms, instead of making those fields as look up in the design view of the table?

coz what I do is I create the relationships of the tables by using the lookup wizard in the design view of tables. so that everytime I add that field to a form, it is automatically a combo box.
Somebody told me that this would cause errors along the way.

can you give me light on this?
Jul 13 '07 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
Bob Larson at that "other place" is often opinionated, but seldom gives out wrong information, which one of the reason's he's the moderator! As he said, it is the prevailing opinion among experts that form based comboboxes is the best way to go!

I don't doubt that you've used the lookup wizard successfully for quite a while, but I suspect you've simply been lucky! I've used memo fields successfully for a number of years, yet that do cause numerous problems to many developers, and I always warn others of the risks in using them!

Linq ;0)>
Jul 13 '07 #2

FishVal
Expert 2.5K+
P: 2,653
calling in Neopa, and mmccarthy,

is it true that it is better to have the comboboxes created in the
design view of forms, instead of making those fields as look up in the design view of the table?

coz what I do is I create the relationships of the tables by using the lookup wizard in the design view of tables. so that everytime I add that field to a form, it is automatically a combo box.
Somebody told me that this would cause errors along the way.

can you give me light on this?
I use lookup wizard for years, it has never made me troubles.

Moreover its my usual practice to change lookup properties (as well as many other field properties) in table design letting Access to update all dependant objects (particulary form controls as I dislike Access reports and never dealt with Data access pages). Again, never makes me problema.

As for me this way is suitable and preferrable.
Jul 13 '07 #3

hyperpau
Expert 100+
P: 184
Thanks guys! I'll keep that in mind. i was not aware that memo fields causes errors down the road.
Jul 19 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.