switchboard failed to link a form with two subforms

[Reggie]

Hi,
I'm building an Access database for a brain bank
in a medical center. I created a base form including two
subforms, one holding number data, one holding photos that
are controlled by a combo box. This form runs pretty well
either independently or initiated by the link in other
forms. But, when I assign this form to switchboard,
switchboard only can partially initiate this form with the
photo part empty. When I selected the photoID from the
combo box, an error message came out. It says: "Run-time
error '3021': No current record". I tried to assign the
switchboard a testing form including the photo part only,
the switchboard worked perfectly.

I'll appreciate very much if anyone can help me to
initiate this base form that includes both data and photo
subforms through switchboard.

Reggie

 

[Estuardo]

-----Original Message-----
Hi,
I'm building an Access database for a brain bank
in a medical center. I created a base form including two
subforms, one holding number data, one holding photos that
are controlled by a combo box. This form runs pretty well
either independently or initiated by the link in other
forms. But, when I assign this form to switchboard,
switchboard only can partially initiate this form with the
photo part empty. When I selected the photoID from the
combo box, an error message came out. It says: "Run-time
error '3021': No current record". I tried to assign the
switchboard a testing form including the photo part only,
the switchboard worked perfectly.

I'll appreciate very much if anyone can help me to
initiate this base form that includes both data and photo
subforms through switchboard.

Reggie

.

Reggie:

Try to requery the form on the On load Event

Good luck

Estuardo

 

[Reggie]

Hi, Estuardo,

I tried to change the Event On Load property of that Form
from original '=HandleButtonClick(6)' to [Event
Procedure]. But I don't know how to fill the VB sub that
has the code ' private sub Form_load() End Sub'. Was
I in the correct direction? Could you please tell me some
details? I appreciate your help very much.

Reggie