Navigation Controls are new to Access 2010 and I suspect this is simply a bug that will eventually be corrected by Microsoft. If this were just a SubForm displayed using the old method, I suspect it would work as you would expect.
Navigation Controls are new to Access 2010 and I suspect this is simply a bug that will eventually be corrected by Microsoft. If this were just a SubForm displayed using the old method, I suspect it would work as you would expect.
Bob Fin and Rural guy
Your code worked for my applications.
I modified it to fit mine - so, this is just a thanks. The data base is my Health and Safety Databse and the interlinked forms are Accident Register and Investigation Register. I needed the accident link feild on the investigation register to auto-populate.
Private Sub Open_Invst_Click()
DoCmd.OpenForm "Investigation Register", acNormal, "", acAdd, acNormal
Forms![Investigation Register]![Accident Link] = Me.[ID]
Exit_Command149_Click:
Exit Sub
End Sub
So, I wouldn't mind now if you could help me re-write the investigation number back into the accident register - ????
cheers.
Is the "Accident Register" form open at this time? If so, you can go through the Forms collection as youn have done with Me.[ID] to the "Investigation Register" form.