How to Update Subform unlinked

  • Thread starter Thread starter Buddy
  • Start date Start date
B

Buddy

Thank you in advanced!

I'm attempting to use an unbound form as an selection
interface to select different criterias to update a
subform within this unbound selection form. How do I
update the subform data without closing and re-opening up
the form. I have already created a requery line in a
button on the form that runs an sql statement.

Buddy
 
-----Original Message-----
Thank you in advanced!

I'm attempting to use an unbound form as an selection
interface to select different criterias to update a
subform within this unbound selection form. How do I
update the subform data without closing and re-opening up
the form. I have already created a requery line in a
button on the form that runs an sql statement.

Buddy
.
Click to expand...
Hi Buddy, did you requery the subform itself (that is the
subform recordsource is requeried) or individually requery
the controls in the subform?

Luck
Jonathan
 
Jonathan

I invoke the query and have requeried the subform as the control. The only way that I have been able to display update the data visual on the subform is the close out the whole form and reopen it. This is a problem because I would like to keep the properties of the listboxes and dropdowns on the unbound main form so that the end-users can still use for other filtering needs. Thanks in advanced

Budd

----- Jonathan Parminter wrote: ----

-----Original Message----
Thank you in advanced
interface to select different criterias to update a
subform within this unbound selection form. How do I
update the subform data without closing and re-opening up
the form. I have already created a requery line in a
button on the form that runs an sql statement
Click to expand...

Hi Buddy, did you requery the subform itself (that is the
subform recordsource is requeried) or individually requery
the controls in the subform

Luc
Jonatha
 
Buddy, try requerying individual controls on the subform.

Luck
Jonathan
-----Original Message-----
Jonathan,

I invoke the query and have requeried the subform as the
Click to expand...
control. The only way that I have been able to display
update the data visual on the subform is the close out the
whole form and reopen it. This is a problem because I
would like to keep the properties of the listboxes and
dropdowns on the unbound main form so that the end-users
can still use for other filtering needs. Thanks in
advanced.
 
Back
Top