?
Solved

Main form and Sub forms

Posted on 2014-12-10
7
Medium Priority
?
114 Views
Last Modified: 2014-12-10
Hello,

Could I do a Main form of my query that is based off one of my table and my table is the sub form..is this possible?
0
Comment
Question by:Jass Saini
[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
  • 4
  • 2
7 Comments
 
LVL 38

Expert Comment

by:PatHartman
ID: 40492041
You can but it doesn't make sense.  You are also likely to get conflict messages if you update data in one of the forms.  Sounds like your table design needs work.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40492068
I with Pat.

This is confusing...

Can you explain what you need here?

ex:
I have a query that displays _______________
I want to have a subform that displays ___________________
I need this because _______________________________
0
 

Author Comment

by:Jass Saini
ID: 40492108
So I am pulling a few fields from table1 and few from table2....parent/child linked by two common fields.

I can go through the records no problem and edit (input data ) into table2.

I don't want to go through all the records to find the hand full of records.  table1 is based on the names of the analyst and I want to pull only those records for that analyst based on the two common fields.
0
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40492142
You can do this , ...but I am still confused by your statement:
"parent/child linked by two common fields."

Typically a Part/Child is linked by *one* common field
tblCustomers.CustomerID--> tblOrders.CustomerID

So in your case you can make the main query the main form "Analysts"  (with a PK of perhaps AnalystID)
then create a subform form the "AlaylstRecords" table (whatever that means), ...again based on the foreign key of AnalystID...
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 40492161
something like this:
Database1x.mdb
0
 

Author Closing Comment

by:Jass Saini
ID: 40492176
Thanks this will work because I already have a tbl with all the analyst names
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40492793
ok
;-)
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
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 …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

766 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