Using Lookup field

  • Thread starter Thread starter Desiree Keener
  • Start date Start date
D

Desiree Keener

I am trying to use the value from one lookup field to
limit the records available for another lookup field.

For instance, I use the lookup field to assign a company
name to a record. I then would like to lookup the contact
at the company. I have assigned this field as a lookup
field, but I would like to limit the records to be only
those contacts for the associated company.

I can get this to work once, but in order to get the
lookup for the contact refreshed, I have to close the
table & reopen it. Is there any way to get the lookup
query to rerun each time I select a new record?

Thanks for any help with this.
 
| I am trying to use the value from one lookup field to
| limit the records available for another lookup field.
|
| For instance, I use the lookup field to assign a company
| name to a record. I then would like to lookup the contact
| at the company. I have assigned this field as a lookup
| field, but I would like to limit the records to be only
| those contacts for the associated company.
|
| I can get this to work once, but in order to get the
| lookup for the contact refreshed, I have to close the
| table & reopen it. Is there any way to get the lookup
| query to rerun each time I select a new record?
|
| Thanks for any help with this.
------------
Hi Desiree,

On the AfterUpdate event of the first lookup, you need to Requery the
second lookup.

Hope this helps,
 
Back
Top