passing value to new second form

[englek]

I have a primary form (based on a parent table) with a button that opens a second form (based on the child table). The two forms are connected by the primary form's primary key (ID). I would like to have the second form open to create a new record with the ID already filled in to prevent user errors.

How I can I do this without creating a subform? I looked on previous posts and saw someone suggested putting

Me.ID.DefaultValue = """" & Me.ID.Value & """"



in the AfterUpdate but this did not work for me

[ketbdnetbp]

Don't know your reason for not wanting to create a subform as it's usually easier. However, be that as it may...

If I'm not mistaken, the code you referred to only works when you create a new record on the same form.

In your case, because you are opening a new form. I would try...

dim transID as long
transID = Me.ID
docmd.openform "your2ndformname"
docmd.gotorecord, ,acNewRec
Me.ID = transID
'optional
'docmd.close "firstformname"

in the OnClick event of the button.

Just a thought,

Jim

[nicknameoscar]

If your ID is a number (integer, long, etc.) instead of a string then try this:

Me.ID.DefaultValue = Me.ID.Value