Microsoft Access question - activate a query using the current record in a form?
-
In my access project for school, I have a query that is used on a single record of the table - the user needs to input the key of the wanted record. Now I have a form and I want to activate the query from the form, but without the input - I want it to use the current record. Is there any way to do this? Thanks, and sorry for any English mistakes, it's not my native language :)
-
Answer:
The query contains the clause WHERE yourkey = [forms]![yourform]![yourkey]; (where "yourform" is the name of your form, and "yourkey" is the name of your key field). The query is activated by the on-click event of a command button on the form.
Chen at Yahoo! Answers Visit the source
Related Q & A:
- How to submit a form using httpurlconnection?Best solution by stackoverflow.com
- How to access the value of a field of the current node in Drupal?Best solution by drupal.org
- If I have a form, such as an application, how can I fill it out using my computer?Best solution by answers.yahoo.com
- How can I record a video using my webcam?Best solution by Answerbag.com
- Is there a free program like Microsoft Access?Best solution by wiki.answers.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.