Auto Refresh of Lookup Field

[MChancellor]

Is it possible to do an autorefresh of a lookup field? Let me attempt to explain what I am trying to do:

I have 3 forms.

Contract Form
Company Form
Contact Form

I have a lookup field on the Contract form that allows the user to look up the Federal ID # for the company. If the Federal Id # is not in the lookup field, I have a button that the user can press to open the Company Form and add the Company information to the Company table. However, I need a way to refresh the lookup list, so that whenever the Company form is closed, and the user again looks at the list, the company will be there.

First of all, is it possible to do this?

If so, how?

Thanks in advance,
M Chancellor

 

[braindead2]

Me.refresh placed in the code of the combos gotfocus event will do it. It needs to be in the code not just on the event line.

 

[MChancellor]

Thanks.. that worked first try.

 

[thowe]

Awsome this works for me! Excellent help!