Pass Data to new form

[mattc66 via AccessMonster.com]

Hi All,

I have a button that I have added to one form. When clicked it opens another
the form I want to pass the ID from the one for to the newly opened for to
start a new record. How would I do that in the on Click event?

Matt

 

[Mr. B]

mattc66,

Use the "OpenArgs" property of the OpenForm command like:

Dim lngRecordID as long
lngRecordID = Me.NameOfControlWithIdValue

DoCmd.OpenForm("SomeFormName"),,,,,,lngRecordID

Then in the OnOpen event your other form you can have code that will read
the OpenArgs value and write it to the proper control:

Me.NameOfIdControl = Me.OpenArgs

HTH
Mr. B
askdoctoraccess dot com

 

[mattc66 via AccessMonster.com]

Thanks I will give that a shot.

mattc66,

Use the "OpenArgs" property of the OpenForm command like:

Dim lngRecordID as long
lngRecordID = Me.NameOfControlWithIdValue

DoCmd.OpenForm("SomeFormName"),,,,,,lngRecordID

Then in the OnOpen event your other form you can have code that will read
the OpenArgs value and write it to the proper control:

Me.NameOfIdControl = Me.OpenArgs

HTH
Mr. B
askdoctoraccess dot com

Hi All,

[quoted text clipped - 3 lines]

Matt