Auto Populate Field

[pjscott]

I'm using sql 2000 and Acces 2003.

I have a form called frmAgencyEmpNew.

Within this form I have several subforms in tab controls.

One of the subforms frmAgencyEmpNewWorkSub has a field Location.

When the Location field is populated from a drop down list I want the field
IdNumber in frmBusOfcData to auto populate with an id number (TL40-729).

I've tried everything I can think of in the After Update but I can't get
anything to work.

Can someone give me an idea what will make this work?

Thanks for the help,

Paul

 

[PJFry]

Is this correct:

frmAgencyEmpNew is the main form. frmAgencyEmpNewWorkSub is a subform on
frmAgencyEmpNew and frmBusOfcData is also a subform on frmAgencyEmpNew.

The field Location is on the subform frmAgencyEmpNewWorkSub and the combo
box IdNumber is on the subform frmBusOfcData.

The location of the subforms relative to main form is key to getting the
answer.

 

[pjscott]

The Location field is on the frmAgencyEmpNewWorkSub.

The field Location is the combo box and it's located on the
frmAgencyEmpNewWorkSub. When the location field is populated I want the
IdNumber field which is on the frmBusOfcData form to auto populate with an
id number somethink like TL40-729. Both the frmAgencyEmpNewWorkSub and
frmBusOfcData forms are on different tab controls.

Thanks,

Paul