Command button (event procedure)

[Nathan23]

I have added a command botton (20) to add new record with the event procedure as follow below:



Private Sub Command20_Click()
DoCmd.OpenForm "sbfAwards_Tracker", , , , acFormAdd, , Me.EIN
Forms!sbfAwards_Tracker.EIN = Me.EIN
End Sub

But its saying compile error:

Method or data member not found.

Any help is appreciated thanks

[ItsMe]

Is there a control named EIN in each of the two forms? If not, which form has the control named EIN?

[Nathan23]

yes both from the Personnel data tbl and Award tracker tbl have Employee Identification Number (EIN). and both Award form and subform have EIN.

[ItsMe]

yes both from the Personnel data tbl and Award tracker tbl have Employee Identification Number (EIN). and both Award form and subform have EIN.

That is not really answering the question I was after.

The following line is opening a form named sbfAwards_Tracker
DoCmd.OpenForm "sbfAwards_Tracker", , , , acFormAdd, , Me.EIN

When the application halts because of the error, click on the "Debug Option". Is it the above line of code that causes the error (highlighted when you click debug)?

[Micron]

Forms!sbfAwards_Tracker.EIN = Me.EIN
If that is a subform referenced (as suggested by sbf) then it is incorrect and could be the member that the message refers to. The syntax for referencing a subform control is
[Forms]![Main form name]![subform control name].[Form]![control name on subform]
Subform control name is the name of the subform control, not the subform.

[ItsMe]

@Micron
Yeah, that may be part of the issue. However, the form being opened has the same name. I guess the mystery continues.