Requery table from form

[Fox]

Hi all,

I am trying to figure out the requery function..... but am not sure this is
the method I need.

I have a main form called projects that has a subform called addcomponents.
the subform addcomponents adds components to the addcomponent table and has a
list box that is populated by the component table.

I've placed a cmdbutton on the projects main form to open the form
components so that components can be added to the componenttable , however
the new components are not available in the list box on the subform
addcomponents until I close the main project form and reopen.
How do I use the requery method so that the subform component list box gets
updated without closing the main form?
Thanks!

 

[Arvin Meyer [MVP]]

In an Event Procedure try:

Me.Requery
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


You can thank the FTC of the USA for making this disclaimer necessary.

 

[Fox]

Where do I put the requery?
On the addcomponent popup form....
on the addcomponent field dropdown list box
On the main form somewhere?
I don't know where to put the requery....on which event...
I have it on several places....but not working ...<S>

 

[Arvin Meyer [MVP]]

Actually upon rereading, I was slightly off. Use the AfterUpdate event of
the subform, and instead of Me.Requery use the listbox name:

Private Sub Form_AfterUpdate()
Me.NameOfListbox.Requery
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Fox]

I actually tried the after update thing and it would not work to update the
list box....
I ended up putting this in the main forms activate event and it actually
worked...not sure why....but after trying them all this one worked so unless
there is a reason not to use this to update a list box that is pulling data
from another table than the main form then I'll just go with it.
Thanks for all your help!!

Private Sub Form_Activate()
[Forms]![StandardStitchesfrm]![Abbreviation].Requery
End Sub