Re: combo box that updates outside table and then needs to be requeried
- From: jleckrone@xxxxxxxxxxx
- Date: 2 Dec 2005 12:08:27 -0800
In the OnClose event of your data entry form, put
Forms!MainFormName!SubFormName!ComboBoxName.Requery
mbs4653 wrote:
> Hello,
> I have a main form with about 6 tabs. On one of those tabs is a
> subform. On the subform, which is used to populate a table, is a combo
> box to look up company values from another table. I put an dbl click
> event on the box, so that if the company is not listed in the drop
> down, the user can dbl click and another form will open that updates
> another table. This outside form works well, but when I go back to the
> subform the new entry is not listed in the combo box, unless one closes
> the whole main form and then goes back into it.
>
> How do I get the combo box to requery and show the results of the
> updated underlying table. I have put the me.requery code in both the
> independent form that one enters the new data, and the subform, but
> neither works correctly.
>
> Any help greatly appreciated
>
>
> --
> mbs4653
> ------------------------------------------------------------------------
> mbs4653's Profile: http://www.hightechtalks.com/m388
> View this thread: http://www.hightechtalks.com/t2300064
.
- References:
- Prev by Date: Re: How to Convert Days(Text field) into Date By giving the start date
- Next by Date: DLookup help
- Previous by thread: combo box that updates outside table and then needs to be requeried
- Next by thread: Re: combo box that updates outside table and then needs to be requeried
- Index(es):
Relevant Pages
|
