Auto Fill Issue #2

[Swilliams987]

I saw the most recent post on autofill, but I wasn't able to follow it. I'm thinking that what I want to learn is frequently done, but I can't seem to find the answer anywhere.

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?

[RuralGuy]

Not being a fan of Macros I can only offer this link: http://www.baldyweb.com/OpenArgs.htm

[Swilliams987]

Thank you for your response, however, I'm not quite sure how to make that work. Perhaps what I want to do doesn't exist.

[RuralGuy]

It most certainly can be accomplished in code but I do not know how to do it in a Macro.

[Swilliams987]

I only need to pass one field.

So would this be the code I would use in the general part of the main form?
DoCmd.OpenForm "frmNotes", , , , , , Me.EmpID
OR
Does it stay looking like this:
DoCmd.OpenForm "frmOpenArgs", , , , , , Me.EmpID

And would this go in the other form?
If Not IsNull(Me.atnpermitnumber) Then
strOpenArgs = Split(Me.atnpermitnumber)
Else
Me.txtOtherInfo = "Unknown"
End If

[RuralGuy]

This is the way you open then next form:
DoCmd.OpenForm "frmNotes", , , , , , Me.EmpID
...and this is in the OnLoad event of the Next form

If Not IsNull(Me.OpenArgs) Then
  Me.TheControlYouWant = Me.OpenArgs
End If

...using *your* TheControlYouWant name of course.

[Swilliams987]

where exactly does the docmd go?

[RuralGuy]

I woud say where this takes place:

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.

[Swilliams987]

VICTORY!!!!!! Thank you so much!

[RuralGuy]

Glad I could help.