Solved

How use split form to query data

Posted on 2013-06-07
1
693 Views
Last Modified: 2013-06-09
Please see the attached screen shot.  I've smudged the data since it is confidential.

What I want to do is use this split form which I have opening maximized in the onopen event of the form.  And in the left hand column I will turn the fields into comboboxes for certain field, not all of them.  I want the user to be able to select a record from the combobox and have only the records that contain that selection to appear on the right.  

Then in the footer of the form I'll need a command button to "Display All Records".  

How can I do this?
ScreenShot.jpg
0
Comment
Question by:SteveL13
1 Comment
 
LVL 19

Accepted Solution

by:
Eric Sherman earned 500 total points
ID: 39230047
<<<<<I want the user to be able to select a record from the combobox and have only the records that contain that selection to appear on the right.  >>>>>



I would use a main form with a sub-form linked with master/child fields from your underlying table/query.

ET
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

930 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now