Here is my issue:
Have an Quality Issues database. Created a query to pull only those issues still left "open". Tied a list box to display the data pulled in the query (Issue, Date of Issue, Who is Responsible, etc) Where I am having trouble is I would like for them to be able to click on the issue in the list and it will take them directly to that record. I can get the form to "pop-up" on the click but it's always a blank record...here is the code. Keep in mind, I suck at access and have never had any formal training in it, but I do have experience in C++ and Visual Basic.
[ID]=[Forms]![TEST FORM]![List Of Open Issues]![ID]
2 1165 NeoPa 32,556
Expert Mod 16PB
Here is my issue:
Have an Quality Issues database. Created a query to pull only those issues still left "open". Tied a list box to display the data pulled in the query (Issue, Date of Issue, Who is Responsible, etc) Where I am having trouble is I would like for them to be able to click on the issue in the list and it will take them directly to that record. I can get the form to "pop-up" on the click but it's always a blank record...here is the code. Keep in mind, I suck at access and have never had any formal training in it, but I do have experience in C++ and Visual Basic.
[ID]=[Forms]![TEST FORM]![List Of Open Issues]![ID]
If we're talking VBA in an OnClick event try :-
Although I'm not clear what the first [ID] is you're assigning to.
Also, the Me. is also redundant for the current form objects but most people seem to like it anyway.
PEB 1,418
Expert 1GB
Hi,
Maybe your list is a combo box which huge number of columns or a list?
So when a record is choosen you need an append query to add the information on a record,
If you want simply to update the current record it should be more easily!
So you need to generate a new record or to change the contents of the current existing record?
:)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Penn Markham |
last post by:
Hello all,
I am writing a script where I need to use the system() function to call
htpasswd. I can do this just fine on the command line...works great
(see attached file, test.php). When my...
|
by: BLUE WATER |
last post by:
Help,
When I am finished entering in data into my form A, I press the save button
that
saves this new data to a new record. However I would like my other form to
open at a specific record, the...
|
by: Daniel Walzenbach |
last post by:
Hi,
I have a web application which sometimes throws an “out of memory”
exception. To get an idea what happens I traced some values using performance
monitor and got the following values (for...
|
by: Rico |
last post by:
Hello,
I have an application that I'm converting to Access 2003 and SQL Server 2005
Express. The application uses extensive use of DAO and the SEEK method on
indexes. I'm having an issue when...
|
by: spidey12345 |
last post by:
what i need this program to do is to read paragraphs like
"st blah blh test ere
se sit blha eere w"
and then it will reformat to
"st blah...
|
by: Mad Scientist Jr |
last post by:
>From an asp.net web page I want the user to open the results of a SQL
query in Excel, as automatically as possible (ie not having to loop
through columns, rows, in code).
For this,...
|
by: Zytan |
last post by:
I have public methods in a form. The main form calls them, to update
that form's display. This form is like a real-time view of data that
is changing.
But, the form may not exist (it is...
|
by: EManning |
last post by:
I''m having problems getting a form to open while going from one tab
to another. I have a tab control: one tab for counties and one tab
for cities. Both tabs have multi-select listboxes. If...
|
by: matheussousuke |
last post by:
Hello, I'm using tiny MCE plugin on my oscommerce and it is inserting my website URL when I use insert image function in the emails.
The goal is: Make it send the email with the URL...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing,...
| |