G
Garry
I am developing a database to keep track of inventory for a home business.
One to the things I have to keep track of is defective merchandise I return
to the supplier for replacement or credit. I usually wait until I have 3 or
4 items before making a return shipment.
The data is stored in 2 linked tables. tblReturn_ShipmentsDefects,
containing RtnShipNo (primary key), date, ShipCost, Shipped (Yes/No), &
Received (Yes/No). ; and tblReturnDefects, containing the details of each
defective item and a RtnShipNo field linked to the main table.
I have a form, frmShip_RtnShipment, that is used to enter the date and
shipping costs when a shipment is made. The form has a subform,
sfrmRtnShip_Defects, listing the defective items in tblReturnDefects linked
by RtnShipNo. This form works fine.
I have another form, frmView_RtnShips, that displays information about
return shipments, with a subform, sfrmView_ReturnDefects, showing the items
in that shipment. This form works fine.
frmView_RtnShips is opened by a command button on a Main Form with VBA in
the OnClick event:
DoCmd.OpenForm " frmView_RtnShips"
frmShip_RtnShipment is also opened by a command button on a Main Form with
VBA in the OnClick event:
DoCmd.OpenForm " frmShip_RtnShipment "
Both of these work fine.
I then wanted to add a SHIP command button to the form – frmView_RtnShips,
that would be enabled & made visible if the current return shipment has not
been shipped. The OnClick event of SHIP is:
DoCmd.Close acForm, "frmView_RtnShips"
DoCmd.OpenForm "frmShip_RtnShipment"
When I click the SHIP button for an unshipped return on frmView_RtnShips,
frmShip_RtnShipment opens, BUT the subform is totally blank (all white, not
even column headings are shown) The only thing I can think of is that there
may be an event timing issue since both of these forms are based on the same
2 tables, but I have no idea what it is. Any help greatly appreciated.
Thanks -- Garry Gross
One to the things I have to keep track of is defective merchandise I return
to the supplier for replacement or credit. I usually wait until I have 3 or
4 items before making a return shipment.
The data is stored in 2 linked tables. tblReturn_ShipmentsDefects,
containing RtnShipNo (primary key), date, ShipCost, Shipped (Yes/No), &
Received (Yes/No). ; and tblReturnDefects, containing the details of each
defective item and a RtnShipNo field linked to the main table.
I have a form, frmShip_RtnShipment, that is used to enter the date and
shipping costs when a shipment is made. The form has a subform,
sfrmRtnShip_Defects, listing the defective items in tblReturnDefects linked
by RtnShipNo. This form works fine.
I have another form, frmView_RtnShips, that displays information about
return shipments, with a subform, sfrmView_ReturnDefects, showing the items
in that shipment. This form works fine.
frmView_RtnShips is opened by a command button on a Main Form with VBA in
the OnClick event:
DoCmd.OpenForm " frmView_RtnShips"
frmShip_RtnShipment is also opened by a command button on a Main Form with
VBA in the OnClick event:
DoCmd.OpenForm " frmShip_RtnShipment "
Both of these work fine.
I then wanted to add a SHIP command button to the form – frmView_RtnShips,
that would be enabled & made visible if the current return shipment has not
been shipped. The OnClick event of SHIP is:
DoCmd.Close acForm, "frmView_RtnShips"
DoCmd.OpenForm "frmShip_RtnShipment"
When I click the SHIP button for an unshipped return on frmView_RtnShips,
frmShip_RtnShipment opens, BUT the subform is totally blank (all white, not
even column headings are shown) The only thing I can think of is that there
may be an event timing issue since both of these forms are based on the same
2 tables, but I have no idea what it is. Any help greatly appreciated.
Thanks -- Garry Gross