UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Can't Requery Subform, Access 2010    
 
   
bis2k
post Aug 10 2018, 07:07 AM
Post#1



Posts: 626
Joined: 12-November 02



I currently open 'Form B' in 'Add' mode from a button on 'Form A'. I use 'Form A' to add persons to a list.
When I close 'Form B' and redisplay 'Form A' I want to re-query a sub-form on 'Form A' that lists the names of the persons added on 'Form B'.

How can this be done.

Thanks
Larry
larrytmerrill@gmail.com
Go to the top of the page
 
BruceM
post Aug 10 2018, 07:38 AM
Post#2


UtterAccess VIP
Posts: 7,574
Joined: 24-May 10
From: Downeast Maine


Have you tried Forms!FormA!SubformControlName.Form.Requery? You could run it from FormB, but I don't know where exactly to suggest placing the code since there is so little detail. Maybe the Close event (assuming it is a dialog form that needs to be closed before anything else can be done).
Go to the top of the page
 
kfield7
post Aug 10 2018, 07:48 AM
Post#3



Posts: 866
Joined: 12-November 03
From: Iowa Lot


Have you considered adding the new person directly to the subform rather than using a separate form?
Go to the top of the page
 
GroverParkGeorge
post Aug 10 2018, 07:59 AM
Post#4


UA Admin
Posts: 33,251
Joined: 20-June 02
From: Newcastle, WA


I also suspect you might simplify the process by adding new people directly in the subform.

On the other hand, if you must use a pop up form, then you can do this:

CODE
Private Sub cmdOpenFormBForInput()

    DoCmd.OpenForm formName:="FormB", view:=acNormal, Datamode:=acFormEdit, windowmode:=acDialog
    With Me
        .YourSubformControlNameGoesHere.Form.Requery
    End With

End Sub


Opening FormB as a modal (i.e. windowmode:=acDialog) suspends the code. When FormB closes, then processing resumes and the subform is requeried.

This post has been edited by GroverParkGeorge: Aug 10 2018, 08:01 AM

--------------------
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    18th August 2018 - 02:41 PM