edit item by double clicking a list control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to double click an item from a list control and have a form pop
up with the item details to be edited. Thanks.
 
I assume that you want to pass the filter from the list box to the form that
you want to open, if that the case, on the DoubleClick event of the list box
you can write the code

Dim MyCondition As String
MyCondition = "[FieldNameInTableToFilter] = " & Me.[ListBoxName]
Docmd.OpenForm "FormName" , , ,MyCondition

=====================
If the field you want to filter is a text type, then change the criteria to
MyCondition = "[FieldNameInTable] = '" & Me.[ListBoxName] & "'"

=====================
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Edit item from listbox control in a popup window 1
List Items Edit Form 2
"Edit List Items" on runtime? 2
Open record from List box 1
Dropdown list in a form allow editing 5
Add/Edit combo box question 3
Two list-box selection on a form 2
Design Question 9

Back
Top