Update subform upong change on another subform

[Xenocide]

Hi

I have a control tab in which I put a subform which his a control tab too.

The second control tab has 2 tabs and I put a subform in each of them.

The first tab (subform1)allow the user to enter a new ID for a new project as well as a couple of information

The second tab (subform2) allow the user to choose between those ID trought a listbox. The problem is that since the both of them are in the same control tab, if the user enter something in the database in the subform1 it won't show in the subform2 unless I close the form completly.

Is there a way for my subform2 to refresh for exemple when I press on the tab to switch subform

 

[PenelopeC]

OnClick event (or wherever you need to make it happen)

forms!formname!controlname.requery

PenelopeC
~~~>-/O~~~~~swimming right along

 

[Xenocide]

it doesn't work but thanks for the help anyway

 

[PHV]

it won't show in the subform2
You mean the new ID isn't in the ListBox ?
You may try something like this:
[ListBox name].RowSource = [ListBox name].RowSource

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244