Stumped on subform

R

RTimberlake

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.
 
S

SusanV

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.
 
R

RTimberlake

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.
 
S

SusanV

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.
 
Top