I have created one main form, under this main form, there is one subform (subform name: SubForm_Production_Schedule) and one button. When this button is clicked, I need the data to display on subform base on certain criteria. Below is the part of the code under the button click event

Quote:

Me!SubForm_Production_Schedule.SourceObject = "Table.Production_Schedule" Me!SubForm_Production_Schedule.Form.RecordSource = "select * from Production_Schedule where Login='" & txtOperator.Value & "'" Me!SubForm_Production_Schedule.Requery Me.Refresh Me.Repaint

However, there isn't any data appear after the button is clicked. When I search back the table Production_Schedule, in fact there are more than 100 rows of data available.

Anyone can advise the what goes wrong to the above coding ? I am using the MS Access 2000.