Solved

Main form and Sub forms

Posted on 2014-12-10
7
105 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
  • 4
  • 2
7 Comments
 
LVL 34

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 Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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 500 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…

746 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

13 Experts available now in Live!

Get 1:1 Help Now