Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!


Discussion in 'Information Technology' started by Garry, Oct 30, 2005.

  1. Garry

    Expand Collapse

    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
  2. Loading...

    Similar Threads Forum Date
    USA Akaal Takhat Forms Committee To Represent US Sikhs Breaking News Sep 13, 2013
    India Poll Reforms On Crash Course Breaking News Sep 7, 2013
    General A Conversation About The Grammatical Forms Of Raam And Simran Hard Talk Dec 1, 2011
    India Anna Says Fast Only "Suspended", Wants Electoral Reforms Breaking News Aug 28, 2011
    India India Announces $5 Bn Aid For Africa, Seeks Support For UN Reforms Breaking News May 24, 2011

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page