requery

[Guest]

I can not get the requery to work - I have a form "Market Orders" and a
subform "Order Details Subform"

When in the subform if it is a new product I use the DbleClick and a new
form opens so that the product can be added

When the form unloads I try to use the Requery but it does not work
..................
Private Sub Form_Unload(Cancel As Integer)

Forms![Market Orders]!Forms![Order Details Subform]![ProductID].Requery


End Sub
.............................

I find requery the hardest instructions to follow

Any help appreciated

 

[Guest]

Hi Nylex,

Try this instead:

[Forms]![Market Orders]![Order Details Subform].[Form].[ProductID].Requery


Order Details Subform, in the example above, needs to be the name of the
subform control on the Market Orders form. This may or may not be the same as
the name of the subform itself, but the important point is that you need to
refer to the container that holds the subform.

Hope this helps.

Happy New Year,


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I can not get the requery to work - I have a form "Market Orders" and a
subform "Order Details Subform"

When in the subform if it is a new product I use the DbleClick and a new
form opens so that the product can be added

When the form unloads I try to use the Requery but it does not work
..................
Private Sub Form_Unload(Cancel As Integer)

Forms![Market Orders]!Forms![Order Details Subform]![ProductID].Requery


End Sub
.............................

I find requery the hardest instructions to follow

Any help appreciated

 

[Guest]

Thank you - worked first time

I can now use the same commands in a few other places in the database that
are very cumbersome

 

[Guest]

You're welcome!

Glad I could help.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Thank you - worked first time

I can now use the same commands in a few other places in the database that
are very cumbersome