alternative to Look-Up wizard

[Ali]

Hello.
Now that I know that the lookup function isn't supported
in queries, is there any alternative data type/process
that would facilitate entering fields that require a list
of data? (I need to be able to access the data in
queries, reports, forms...also.) Any suggestions would be
very helpful. Thanks!

Ali

 

[Lynn Trapp]

Use Combo boxes on your form (which can have a query as it's Record Source).

 

[John Vinson]

Hello.
Now that I know that the lookup function isn't supported
in queries, is there any alternative data type/process
that would facilitate entering fields that require a list
of data? (I need to be able to access the data in
queries, reports, forms...also.) Any suggestions would be
very helpful. Thanks!

Ali

Well, don't use either Table or Query datasheets for routine data
entry. They're very limited.

Instead, use Forms - with combo boxes ("lookups"), listboxes,
subforms, and the many and varied tools Access provides to make data
entry simpler.