Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

Form Input is repeating through all queried records

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
Jass Saini
Asked:
Jass Saini
  • 3
  • 2
2 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
Jass SainiAuthor Commented:
Doc1.docx  Hopefully you can see this...  I cant copy and paste into here for some reason.
0
 
EirmanCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Jass SainiAuthor Commented:
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
 
EirmanCommented:
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
 
Jass SainiAuthor Commented:
Thank You
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now