Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How use split form to query data

Posted on 2013-06-07
1
Medium Priority
?
786 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
[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
1 Comment
 
LVL 19

Accepted Solution

by:
Eric Sherman earned 2000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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.

610 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