I have a DB in Access that I am pulling search criteria from a table using a query and then displaying those results into a tabular form. However, when I close out of the forms/queries etc. the data is being saved to the table. My query is a "select" query not append so I am not sure why this would happen. It will even add a record if no records exist for that recordset. Any help would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Query Results Saving To Table
- Thread starter kdenney
- Start date
There may be people using this Access Database for data entry at my church who may not know the intricacies of how to edit data so our idea was to make it as user friendly as possible by having fields in a form that they input data with and then it searches the data in the tables and displays the results etc.
The problem is that when we have a form that enters criteria and runs it then adds that criteria to the original data even though clearly that isn't what we want.
FYI I could even send the file to an email recipient as well if needed.
We just need to know why/how the form once submitted adds that criteria back to the table. Clearly when we run the query it doesn't add the data so the problem is with the form. Why would a form do this?
The problem is that when we have a form that enters criteria and runs it then adds that criteria to the original data even though clearly that isn't what we want.
FYI I could even send the file to an email recipient as well if needed.
We just need to know why/how the form once submitted adds that criteria back to the table. Clearly when we run the query it doesn't add the data so the problem is with the form. Why would a form do this?
Upvote
0
Excel Facts
VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
Well, as I explained earlier, any form or query can be bound to a data table in an interactive manner, meaning it can be used to edit, add, or delete data (even if it's "only" a select query). This a feature of Access.
It's not necessarily the case that as soon as you put some textboxes on a form you have a search form all ready to go. What else did you do to create this form?
It's not necessarily the case that as soon as you put some textboxes on a form you have a search form all ready to go. What else did you do to create this form?
Upvote
0
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
BTW you are describing a form for editing data so this is at odds with your statement that the form should only be for searching and viewing data. From the above, it sounds like you do want data changed in the tables ...
This might help on using comboboxes for navigation but IMHO it is much much simpler to engage in 10 minutes of training with your users on how to use form search and filter tools. They are also immensely more powerful and all without a moment of extra effort on your part.
http://allenbrowne.com/ser-03.html
Last edited:
Upvote
0
Similar threads
- Question
- Question
