Recent content by simonliu149

Thanks Gemma, that worked like a charm! I first executed a SQL INSERT INTO statement that inserted a new record into the underlying table, changed the second subform's RecordSource to point to this newly inserted record (via a SQL SELECT statement), and then requeried the second subform. So the...

Hi guys, I've got a problem with programmatically creating a new record in a subform from a different subform. Currently, the main form (frmMain) alternatively displays either subform 1 (sfrmSubform1) or subform 2 (sfrmSubform2), depending on what the user has selected. This switching is done...