requery to add information to subform

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

In my subform I have a button that adds a reord to a data
sheet from a combo selection. I cannot get the record to
add with the on click selection. If I close and reselect
the form for that order it appears at that time I would
like it to appear without closing the form down.

Cheers
 
Hi,

What you will need to do is add the requery function to
the code of your command button. Add it at the end of
the code, but before the End Sub (or error handling if
you have any)

If the command button is in the subform the code is:

Me.requery

If the command button is in the mainform the code is:

Me!NameOfSubform.Form.Requery

Hope this is of some help.

Regards

Julie
www.simply-access.com
 
Julie,
I never had the time to learn VB and have been finding ways around it. I ran into the same problem as Tony, and tried using a macro, but I couldn't get it to work. Is there another way to requery a subform without using VB? Thanks.
 
Back
Top