Automatic Population of Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a subform based on a query.

One element of the query is based on a text box on the main form.

How do you get the subform to automatically populate when you hit enter
after entering the data in the text box.
 
You'll need to Requery the subform...

Use the AfterUpdate of your Text control.

Me.frmSubForm.Requery

hth
Al Camp
 
In the Child and Master field links, set the Child link to the field you
mention from the query. Set the Master link to the textbox on the main form.
Make sure the textbox has a unique name.

If the query is looking at the value of the textbox, you would use the
AfterUpdate event of the textbox to Requery the subform. However, removing
the filter from the query and using the above method may work better for
you.

Example Requery:
Me.NameOfSubformControl.Form.Requery
 
Back
Top