switchboard failed to link a form with two subforms

  • Thread starter Thread starter Reggie
  • Start date Start date
R

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
 
-----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

.
Click to expand...


Reggie:

Try to requery the form on the On load Event

Good luck

Estuardo
 
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
 
Back
Top