HOW CAN I ASSIGN RECORDSET TO THE SUBFORM IN ACCESS [Archive]

View Full Version : HOW CAN I ASSIGN RECORDSET TO THE SUBFORM IN ACCESS

pramoc

07-16-2007, 03:59 AM

HOW CAN I ASSIGN RECORDSET TO THE SUBFORM IN ACCESS

mattj

07-23-2007, 08:24 AM

If you're in the main form:
Me.YourSubform.RecordSource = "some SQL string" or name of query
Me.YourSubform.Requery

If you're in the subform:
Me.RecordSource "some SQL string" or name of query
Me.Requery

HTH
Matt