I have a form that is being populated with a Query....I have a few blank fields.. When I input a number, that number carries on the whole field for all the records that were queried and this is not what I want. I only need it to be a input for that record. How do I accomplish this?
Form By Query
- Thread starter Jass7869
- Start date
- Local time
- Today, 15:04
- Joined
- Jul 9, 2003
- Messages
- 17,542
Do you mean the record source of your form is a query?
I need to see your DB in order to try to help you.
The DB as structure, not the info that you store in.
So, remove all the info from your DB, then fill the tables with information like
Person , Function , Age
Jon Doe , US president , 4
then post the DB.
Do not forget to keep the original
The DB as structure, not the info that you store in.
So, remove all the info from your DB, then fill the tables with information like
Person , Function , Age
Jon Doe , US president , 4
then post the DB.
Do not forget to keep the original
- Local time
- Today, 15:04
- Joined
- Jul 9, 2003
- Messages
- 17,542
And don't post the whole database only the parts that are not working properly
Yes my form is based off a query...I am still new to Access as I don't understand all the terminology. I apology in advance. I have two tables populating the query and then from the query I made a form to input data...Numbers. As I work for accounting. I have a few unbound fields where the user can input numbers (+/-) dollar amount. But from the query if I have fourteen selected records and I am adding 10K..it adds 10K to all the records. The fields are Unbound...
- Local time
- Today, 15:04
- Joined
- Jul 9, 2003
- Messages
- 17,542
If you are new to access then why are you using unbound ... Scrap that... As Mihail suggested, you need to post your dB.
The fields are Unbound...
And this is the problem.
In fact you have a SINGLE control (text box) but you see the image of this control many times.
Do a test:
Drag your text box in the header area of the form then fill it with data.
And this is the problem.
In fact you have a SINGLE control (text box) but you see the image of this control many times.
Do a test:
Drag your text box in the header area of the form then fill it with data.
Hello..did that...same results. Sorry I am trying to do a screen capture, but its not allowing me to paste into this comment box. So what's wrong with using unbound textboxes??? If I bound them to a field, I can't put input into it.
- Local time
- Today, 15:04
- Joined
- Jul 9, 2003
- Messages
- 17,542
You say what's wrong with unbound text boxes? Well there's nothing wrong with using them, however when you close the form the information will be lost; if you move to a new record the information will be lost. So how do you propose to store the information?
- Local time
- Today, 15:04
- Joined
- Jul 9, 2003
- Messages
- 17,542
Why do you need to do it that way? Why can't you add the input through a form based on the table, as per the normal built in functionality of MS Access?
So I was given this DB already started by another person...the first form search by Analyst for what they are responsible for--a query joined by two tables. Now that I have the query--my boss wanted me to add six columns --every other column to be a calculated field based off the previous field. I dumped the query into a form to help the user input the number for the calculation. This is where I am having the problem..if the query has fourteen records that returned..and the user enters a number ..it populates all the records for that field.
- Local time
- Today, 15:04
- Joined
- Jul 9, 2003
- Messages
- 17,542
Ah right... Well it sounds like you have inherited a poorly designed dB which you are patching up to the tune of a. n. other. I don't envy you your position! I can't see that I can help so I'll get out of the way.
Thank you for trying...We have tables that have fields that don't mean a thing..but our boss wants in the table for next time. Even the two tables I had to join to get a query that was based on the Analyst that was hard enough...after I fix this problem I have to figure out if I want to dump all the info into another table as I am only working with the queried records and I have over 7100 records. Again Thanks for your help. If you come up with something let me know.
