Cannot open form by double clicking list box


HOME ยป Access

When double click the entries given in the attached database I cannot open the correct form. it gives parameter value.
kindly help me to overcome this error.
Fox

Related to : Cannot open form by double clicking list box
Open form by Double clicking on a Listbox
Access
I have currently created a few search fields where the results appear in a listbox. What I am hoping to do is to double click on a specific record in the listbox and have it open up to a form with all the details in it. Currently my code for the listbox is:
Private Sub lstMSDNInfo_DblClick(Cancel As Integer)
'Open frmMSDN based on the ID from lstMSDNInfo listbox
DoCmd.OpenForm "frmMSDN", , , "ID = " & Me!lstMSDNInfo, , acDialog
End Sub
When I run it, it just gives me a syntax error The OpenForm action was cancelled. When i debug it it takes me to:
DoCmd.OpenForm "frmMSDN",
Double clicking Query list box results
Access
Hi,
Does anyone know how I can set up the following?
I have a form with a list box in it which is populated by the data from a query.
What I would like is that when a user clicks on one line of data so that the line goes black and the text goes white, I would like the code that when double clicked, will take you to a form with the record displaying the same data as the one that was in the list box.
E.g. The list box would be a work queue of outstanding post items to action and when a record is double clicked on, it takes you to another form but shows all of the data for that record as opposed to just the data in the list box query r
Double Clicking Record In List Box to Open Hyperlink
Access
Hi all,
Seems I have a lot of questions today! I have a list box on a form with four columns/fields : Item Name, Item Category, Item Description and Item Photo. The Item Photo is a hyperlink to a file for that specific item's photo on a networked PC.
Is it possible to: on double clicking the particular record in this list box, open the hyperlink?
Thanks very much!:rolleyes:

Edit record in list box by double clicking
Access
I want to write some code that will change the state of a parameter for a record in a table if I double click on it in the list box. How can I do this?

Double Clicking Record In List Box to Open Hyperlink Take 2
Access
Good morning all,
I have still been unable to find a way to do this:
I have a list box "Item List"on a form "Order Form"with these columns/fields : Item ID, Item Name, Item Category, Item Description, Item Photo and WH Stock taken from a query "Stock In Store/WH".
The Item Photo is a hyperlink to a file for that specific item's photo on a networked PC. On double clicking a specific record, I would like the hyperlink to open.
Thanks very much

Cannot open form by double clicking list box
Access
When double click the entries given in the attached database I cannot open the correct form. it gives parameter value.
kindly help me to overcome this error.
Fox


Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .