Solved

Combo Box on Subform only updating related records in Main form.

Posted on 2015-01-06
2
249 Views
Last Modified: 2015-01-06
I have a Main Form "frmInvoice" and a subform "subfrmShipments". Linked on InvoiceNumber field. One invoice to many shipments.

Combo Box on subform has rowsouce as SELECT ShipmentID, InvoiceNumber, TrackingNumber FROM tblShipments;
and in after update event
Me.RecordsetClone.FindFirst "[ShipmentID] = " & Me![Combo15]
Me.Bookmark = Me.RecordsetClone.Bookmark

Problem is the Combo Box only updates / finds the records relating to the invoicenumber on the main form. Is there a way to get it to update even if the main form is not currently on the related InvoiceNumber?

Scaled down version of db attached.  First frmInvoice record has 3 shipments, if selecting the fourth record in the drop down of the Combo Box the record is not selected.
Invoice.zip
0
Comment
Question by:ExpressMan1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 40534473
is this what your looking for
Invoice-Rev.zip
0
 

Author Closing Comment

by:ExpressMan1
ID: 40534574
Perfect! Thank You Rey.

Now to study the code and learn from it.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question