add new record - link between forms doesn't work

[victoriajayne]

after pulling my hair out for quite some time I thought I would ask:

I have two forms that are linked in the normal way so that when you go between them the common field should enable them to show the relevant record. This works fine unless I add a new record in the first form, then when I go to the second form the link doesn't work any more. The debug.print shows that the number is being passed as normal, but the second form will not display the correct (or new) record, but instead goes to a blank record.

Thank you

 

[dynamictiger]

I think you are not saving the record in the first form. You may need to force save it for the second form to work correctly.

docmd.runcommand accmdsaverecord

hth