Solved Refresh Subform

[Gr3g0ry]

can i refresh a subform from OnChange of combobox ? if so, how can i achieve that ? please and thanks

 

[theDBguy]

You can use either Refresh or Requery. Which one did you try?

 

[Gr3g0ry]

You can use either Refresh or Requery. Which one did you try?

i tried none.
so how would i do this ? would i just use formname.requery in the OnChange of the combobox ?

 

[theDBguy]

i tried none.
so how would i do this ? would i just use formname.requery in the OnChange of the combobox ?

If the Combobox is also on the form you want to refresh, you could simply try:

Me.Refresh

or

Me.Requery

If you already have any code in the Change event, could you please post it? Thanks.

 

[Galaxiom]

The difference between Refresh and Requery is important.
Refresh only get the updated values in the already loaded records.
Requery reloads the RecordSource so includes new records and reflects any changes to the query and its parameters.

 

[Deleted member 147267]

...and requery also brings you back to the first record. Can be bothersome if you wanted to stay, say, 200 records down in a datasheet or continuous form.

 

[Gr3g0ry]

If the Combobox is also on the form you want to refresh, you could simply try:

Me.Refresh

or

Me.Requery

If you already have any code in the Change event, could you please post it? Thanks.

frmPartnerDraws.Requery
frmPartnerPayments.Requery

i put these in the AfterUpdate event and they work just fine

 

[theDBguy]

frmPartnerDraws.Requery
frmPartnerPayments.Requery

i put these in the AfterUpdate event and they work just fine

Glad to hear you got it sorted out. Good luck with your project.