Setting value of hidden fields when adding new field

[jobrien4]

I have a form (frm_Parts) where the user will input part number, reivision number, and customer number and the record of that part comes up in the form. If this part has a bevel operation, a button with "Show Bevel Info" appears.



Upon clicking that button, frm_BevelInfo is launched in a new tab using an OpenForm macro (where the part number, revision number, and customer number from the first form equal the same fields in frm_BevelInfo). I set this table up as multiple items tabular form, because the same part can have multiple bevel operations that I want to all show up at once.

Here is my problem/what I want to accomplish. If the part from the frm_Parts doesn't have a bevel operation already, when frm_BevelInfo is launched, there is no way to add a new field.

Also, I want to have the Part Number, Reivision Number, and Customer Number hidden on frm_BevelInfo since this info is redundant to frm_Parts. However, when the user clicks an "Add New" button, I want to have these fields set to whatever the info is in frm_Parts.

I tried to use a
GoToRecord (New),
SetValue - [PartsNumber] - Forms![frm_Parts]![PartNumber]

But it doesn't work. Anybody have any advice?

[ssanfu]

Try:

    DoCmd.GoToRecord , , acNewRec

    Me.PartsNumber = Forms![frm_Parts].[PartNumber]