Subforms - why does it not bring up a new record......

N

Nick Pedder

Hi,

I was wondering if anyone could help with this small problem I have here…

I’m in the process of designing a database which stores ‘HR Procedures’ for individual staff members.

The form ‘frmHrProcedures’ is linked to ‘frmStaffDetail’ and appears as a subform.

From a menu form I would like the database to open a new record for a new member of staff each time. Now I’ve managed to do this with a macro on the ‘frmStaffDetail’, but the subform doesn’t ‘refresh’ itself. For some reason using a macro to open a new record on the subform will not work.

I’m a bit stuck on this and would really appreciate it if any one knows how to get round this !

Thanks

Nick
 
Top