Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2015-01-06
2
Medium Priority
?
276 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
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

926 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