Recordsource - display problem

[Martin Dashper]

I have a bound form which, when the Record Source is hardwired on the
data tab of the form's properties, will display all appropriate
records. However, if I set the Record Source in code eg.
(Me.RecordSource = "myTable"), it only displays the first record.

Any Suggestions?

Martin Dashper

 

[Allen Browne]

Martin, is this form a subform?

If so, you may need to also programmatically clear the subform control's
LinkMasterFields and LinkChildFields properties. When you assign the
RecordSource, Access has a guess and sets these to whatever it feels like.

 

[Martin Dashper]

No, it is not a subform, it is a form created by the form wizard (in a
tabular layout) and is opened from another form using
DoCmd.OpenForm.....

Martin

 

[Allen Browne]

Okay, in what event are you changing its Recordsource?

Post the code.

 

[Martin Dashper]

I've tried in both 'On Open' and 'On Load'

Dim tableName As String
tableName = "tblDaySheet_Martin2"
Me.RecordSource = tableName

I have also tried the above using the table's name directly without
the intervening variable.

Martin