Subform not displaying data

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

Guest

I have a bound main form with one subform. The subform is linked to 3
textboxes on the main form. The textboxes contain the keys to the data in
the subform. The textboxes changes value based on what I select in a combo
box on the main form.

The problem is that the subform doesn't display any data regardless of when
the textboxes change value. There is data in the table when I just open the
subform on its own.

Subform properties:
Allow Edits/Deletion/Additions = Yes

I have another form with the same setup but different info and it works.
Any help would be much appreciated. What am I missing?
 
How did you link the subform to the 3 fields?
You might run a requery on the sub form, after the values are entered in the
text boxes

Me.SubFormName.Requery
 
Thanks for the reply. I already have me!HistorySub.Form.Requery in the
Change event of the combo box that changes the values of the textboxes. But
this still doesn't work.

The link for subform is through the Master/Child link fields:

Child link fields: St;Reg;Dist
Master link fields: txtSt;txtReg;txtDist

The textboxes are changed through the Change event of the combo box.
Something else I might be overlooking?
 
Back
Top