Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2015-01-06
2
Medium Priority
?
268 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 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

722 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