Solved

Form Input is repeating through all queried records

Posted on 2014-12-02
6
153 Views
Last Modified: 2014-12-08
Hello,

I have a form that was built off a query and I have a blank field that comes from one of the two tables (queried).  I need the user input for this field.  I am running a test.  Everytime I enter a value, that value repeats to all the queried record.  Please help!
0
Comment
Question by:Jass Saini
  • 3
  • 2
6 Comments
 
LVL 84
ID: 40477460
Are you using a Continuous Form? If so, then the control will need to be "bound" to a ControlSource.

If not, perhaps you could post a screenshot of what you're referring to.
0
 

Author Comment

by:Jass Saini
ID: 40477555
Doc1.docx  Hopefully you can see this...  I cant copy and paste into here for some reason.
0
 
LVL 23

Accepted Solution

by:
Eirman earned 500 total points
ID: 40478231
Does your form have a subform (or is it a split form)?
Could you post a screenshot of the 'relationships'

If your form has a subform, then you should link the 'master field' and 'child field' (which should be unique values)
These should be in the tables in the underlying the query upon which the form is based.

There should be a one-to-many relationship between the two tables for a continuous sub-form.

If you link the parent form and the subform with a field that does not contain unique values
you may get the type of results you have at the moment.
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:Jass Saini
ID: 40478865
I set up a sub form but now when I run the query it is asking for the master and child field that I set which is the ID in the Final table.  If I don't put anything in there then that field in the query goes to Expr1...and is blank.  I need that field to tie my main and child form together.  How do you get around that??  Also my child form font is too big.  Looking to where I can make it smaller in the properties
0
 
LVL 23

Assisted Solution

by:Eirman
Eirman earned 500 total points
ID: 40479669
It would be a big help if you could you post a screenshot of the 'relationships'

To tie the two forms together you need to have a one to many link between the two link fields (in the tables)
Do a search for create subform in access
There's loads of stuff available

To reduce the font in the subform just open the form in design view
(there should be a button on the top right called "Subform in new window")
0
 

Author Closing Comment

by:Jass Saini
ID: 40487709
Thank You
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
HasData 9 39
Open a Specific Record With a Specific Tab Page 5 31
data analyst 3 50
error 3022 in access vba 3 18
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

863 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

23 Experts available now in Live!

Get 1:1 Help Now