Error 2465 while opening a form

[ontherun]

hi,

i have two forms CHS_Customer and 'CHS_Job'
both have a common field, "Company_Name"

i want to open the form 'CHS_Job' from the form 'CHS_Customer ' and when i open, the Company_Name field value in 'CHS_Customer' but be assigned to Company_name field in 'CHS_Job'

i have written some code for the button "Enter Job" in the Form 'CHS_Customer '

Private Sub EnterJobLabel_Click()

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

DoCmd.OpenForm "CHS_Job"
DoCmd.GoToRecord , , acNewRec

[Form_CHS_Job].Company_Name.Value = Company_Name.Value

End Sub


the above code gives run time error 2465: Access cant find the field ' I ' referred to in the application.

I have checked the fields and there is nothing wrong.

what would be the problem??
need your assiatance

thanks n regards,
Kathy

[kepston]

I think this

[Form_CHS_Job].Company_Name.Value = Company_Name.Value

should be

Forms![Form_CHS_Job]!Company_Name.Value = Company_Name.Value

[puppydogbuddy]

hi,

i have two forms CHS_Customer and 'CHS_Job'
both have a common field, "Company_Name"

i want to open the form 'CHS_Job' from the form 'CHS_Customer ' and when i open, the Company_Name field value in CHS_Customer but be assigned to Company_name field in 'CHS_Job'

i have written some code for the button "Enter Job" in the Form 'CHS_Customer '

Private Sub EnterJobLabel_Click()

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

DoCmd.OpenForm "CHS_Job"
DoCmd.GoToRecord , , acNewRec

[Form_CHS_Job].Company_Name.Value = Company_Name.Value

End Sub


the above code gives run time error 2465: Access cant find the field ' I ' referred to in the application.

I have checked the fields and there is nothing wrong.

what would be the problem??
need your assiatance

thanks n regards,
Kathy

Hi Kathy,
When you have more than one form opened at the same time, you need to use fully qualified references as shown:

Change this:
[Form_CHS_Job].Company_Name.Value = Company_Name.Value

To this:
Forms![Form_CHS_Job]!Company_Name.Value = Forms!CHS_Customer!Company_Name.Value

[ontherun]

Kepston and Puppy,


U guys rock... man, it solved the problem ..

thanks guys..thanks a lot...

take care

chuz,
Kathy