Stumped on subform

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

Guest

Here is a good one for ya.

I have a form that has multiple subforms on it. One of the subforms that I
have attempted to add will not work. I created the subform seperatly from the
form. When I did this everything worked great I have two feilds on this
subform. Charge category and legal charges. When the user chooses a category
the list for legal charges is limited to the charges that are under that
category. Things work beautifully. However, when I put this subform on my
main form, it no longer works.
It gives me a message box: "The LinkMasterFields property settin has
produced this error:'PRocedure declaration does not match description of
event or procedure having the same name.'"
I didn't change anything on my form. What happened and how can I fix it?

Here is how things are set up:
sfrmCharges
Category - RowSource "SELECT DISTINCT tblCharges.Category FROM tblCharges;"
- Even Procedure
Private Sub cmbCategory_AfterUpdate()
Me.cmbLegal.Requery
End Sub
Legal - RowSource "SELECT tblCharges.Legal FROM tblCharges WHERE
(((tblCharges.Category)=forms!sfrmCharges.cmbCategory)) GROUP BY
tblCharges.Legal ORDER BY tblCharges.Legal;"

This table needs to be placed on frmMaster.

Thank you for your time and your help.
 
Right-click on the outer edge of the subform >>Properties>>Data tab. Verify
your link child and link master fields are set to the same field.
 
I checked that and could not find the place to check wether or not the child
and master feilds are the same. However, I inserted the supform again and
made sure that the child and parent feilds were the same. It still does not
work.
 
If the subform is not very complex (and it sounds fairly simple) I would try
actually CREATING it via the Subform wizard, in order to determine where the
link is breaking.
 
Back
Top