Double Click List Box!

[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)

 

[Tom Wickerath]

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"

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
__________________________________________

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)

 

[paul]

, qryHor