Auto-Fill one field, two tables, two forms

[Swilliams987]

I have a form: frmNewPermit. They primary key on this form is atnpermit.

On this same form, I have a macro that, when clicked, displays another form based off of another table to enter in notes. This form is called frmNotes. The primary key is also an atn. I need atnpermit from frmNewPermit to automatically fill the lngPermitNumber field on frmNotes.



Would anyone be kind enough to offer a suggestion?

[Swilliams987]

I think I may have posted this in the incorrect location.