Double Click List Box!

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

I have a List Box on my Form [lstNotInvoicing] which comes from a this
query........
SELECT qryHorseList.Invocing, qryHorseList.Name,
DCount("Name","qryActiveNoInvoicing") AS [Count],
funGetHorse(0,tblHorseInfo.HorseID,True) AS Expr1,
funGetHorse(0,tblHorseInfo.HorseID,False) AS Expr2, qryHorseList.HorseID
FROM qryHorseList
WHERE (((qryHorseList.Invocing) Like "No"))
ORDER BY funGetHorse(0,tblHorseInfo.HorseID,True),
funGetHorse(0,tblHorseInfo.HorseID,False);

Is it possible to have an event on my Double-click event in the list box
that will change my Horse/HorseID to "Yes"
The table is tblHorseInfo.Invocing (Text Field, Yes/No)
 
Hi Bob,
Is it possible to have an event on my Double-click event in the list box
that will change my Horse/HorseID to "Yes"
Click to expand...

This sounds do-able to me, but I think you want to change the data stored in
the Invocing (sp) field, instead of altering the Horse or HorseID. It might
be easiest to use a list box that has the Multiselect property set to No. In
the DoubleClick event procedure, you can run an update query to update the
value of the selected record, as long as your list box row source includes a
primary key (or unique index), such that you can uniquely identify the
selected record. This key value need not be displayed in the list box (set
column width to zero).


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Bob Vance said:
I have a List Box on my Form [lstNotInvoicing] which comes from a this
query........
SELECT qryHorseList.Invocing, qryHorseList.Name,
DCount("Name","qryActiveNoInvoicing") AS [Count],
funGetHorse(0,tblHorseInfo.HorseID,True) AS Expr1,
funGetHorse(0,tblHorseInfo.HorseID,False) AS Expr2, qryHorseList.HorseID
FROM qryHorseList
WHERE (((qryHorseList.Invocing) Like "No"))
ORDER BY funGetHorse(0,tblHorseInfo.HorseID,True),
funGetHorse(0,tblHorseInfo.HorseID,False);

Is it possible to have an event on my Double-click event in the list box
that will change my Horse/HorseID to "Yes"
The table is tblHorseInfo.Invocing (Text Field, Yes/No)
Click to expand...
 
Back
Top