Link to home
Start Free TrialLog in
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!
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

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

ASKER

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

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank You