Refresh Subform form a mainform

[GovtWerker]

I have two forms:
Bulk Funding Form
Bulk Funding Form Sub

I dragged and dropped the Sub into the Main Form
The Main Form has a Combo Box (List45)
that OnChange does a dbs.CreateQueryDef("Ending Balance1" to create a query based on what value was selected in the ComboBox, part works fine

The problem I have is the SubForm is open and when the value changes I have been unsuccessful getting the subform to refresh with the current data.

I hope I've adequately described the issue. OOPs, My boss just IM'd me I gotta give a status on this DB,

GovtWerker.

 

[Trevor G]

You need a relationship between the main form data and the subform data, so delete the Event you added for after Update and in then select the subform and open the properties you need to link the Master To Child Fields that will requery the form.

I don't see any built relationships in your database.

 

[GovtWerker]

Trevor G,

It took me a while to figure out how to do the relationship part. The Sub form is now updating, but it is only working on the first value in the combox box. the query is updating though. I'll keep tinkering.

thanks for help!

GovtWerker