Referencing a control on a subform

[ramprat]

Hi Everyone,

I thought I had this right but I can`t understand why I get this error. When Access encounters the line of code below it says Microsoft Access cannot find the field traffic_subform referenced in your expression.

The traffic_subform is a subform of the count_stations_form and I`m trying to reference a control on the traffic_subform.

ElseIf rs.RecordCount = 0 And Forms![Count_Stations_Form]![Traffic_Subform].Form![Number_of_Records] = 1 Then

Any ideas

Thanks as always.

Ramprat

[puppydogbuddy]

Your reference depends on whether the code that includes the reference is executed from the main form or from the subform. The reference you provided above appears to be the correct reference syntax used in code executed from the main form. If, however, the reference is being made in code being executed from the subform, then your reference would look as shown below. Could that be your problem?

ElseIf rs.RecordCount = 0 And Me![Number_of_Records] = 1 Then
__________________________________________________ _____

If the above is not the problem, it would appear that your reference should be to the recordset object (rs!xxxxxxxxxxxx) and not the form object directly..

[LBryant]

If you are getting the recordcount of your subform from the main form or the subform itself, you can use the RecordCount property. In this example, MySubform is the "name" of the Subform control on your main form.

From main form:

NumberOfRecords = MySubform.Form.Recordset.Recordcount

In the subform's code, you can use:

NumberOfRecords = Me.Recordset.RecordCount

[ChipR]

I always get confused and go back to this chart:

Forms: Refer to Form and Subform properties and controls

[ramprat]

Thanks guys. The combination of answers helped me sort it out.