Solved

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

Posted on 2015-01-06
2
259 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

636 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