Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2012
    Maia - Portugal

    Unanswered: Populate subform with retrieved data from a basic table

    Good day !

    Please kindly look at the attached database and word document that contains my gentle request. I'm not an expert on VBA so I'd like to ask senior help.

    Goal : After entering Port Of Loading and Port Of Discharge on main form , I want to click label “POPULATE” and it runs an event that will look up FCA table for records meeting criteria :

    Port Of Loading (main form) = POL (on FCA table) AND Port Of Discharge (main form) = POD (on FCA table). Sub form would then be populated with all records on FAC meeting criteria and table Quot1_OceanFreight would save these records.

    Please use POL = PTLEI and POD = GBFXT once it contains more than one record on FCA table.

    The solution to this would just make my day !!!!
    Many thanks.

    Paulo Jorge
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts