Lookup in tables

[hyperpau]

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?

[missinglinq]

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)>

[FishVal]

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.

[hyperpau]

Thanks guys! I'll keep that in mind. i was not aware that memo fields causes errors down the road.