manix
Registered User.
- Local time
- Today, 07:56
- Joined
- Nov 29, 2006
- Messages
- 100
HI All,
I have a small question. I have a form that can be opened from another form to add a record to a combo box. So if the use looks at the drop down list from the combo box and they cannot see the item they require, they can click a button and "add" the required item to the list.
In order for this to work correctly and update the list as soon as they exit the "add" form, I have the following code working on the On Exit:
Now this is fine if I only want to use the add form on the [frm_concern] form. However, I would like to make use of this form on other forms where the combo list appears. How do I do that? Sorry I am not up to speed totally on VB!
TIA
I have a small question. I have a form that can be opened from another form to add a record to a combo box. So if the use looks at the drop down list from the combo box and they cannot see the item they require, they can click a button and "add" the required item to the list.
In order for this to work correctly and update the list as soon as they exit the "add" form, I have the following code working on the On Exit:
Code:
Forms![frm_concern]![Supplier].RequeryNow this is fine if I only want to use the add form on the [frm_concern] form. However, I would like to make use of this form on other forms where the combo list appears. How do I do that? Sorry I am not up to speed totally on VB!
TIA
