Avatar of Jass Saini
Jass Saini
 asked on

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!
Microsoft Access

Avatar of undefined
Last Comment
Jass Saini

8/22/2022 - Mon
Scott McDaniel (EE MVE )

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.
Jass Saini

ASKER
Doc1.docx  Hopefully you can see this...  I cant copy and paste into here for some reason.
ASKER CERTIFIED SOLUTION
Eirman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jass Saini

ASKER
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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Jass Saini

ASKER
Thank You