How do I reference the current record in a table from a lookup?

[Guest]

I am trying to use a field from the current record in a table as a where
clause parameter in a Lookup query. I don't know how to reference the current
record in a table from this lookup query... Any ideas?

 

[Rick Brandt]

I am trying to use a field from the current record in a table as a
where clause parameter in a Lookup query. I don't know how to
reference the current record in a table from this lookup query... Any
ideas?

In a table youcannot. Use a form.

 

[Guest]

Rick - Thanks for the quick reply - I have used a form