Help with Query!

[arthurjr07]

that is a very tough one. hahaha

ROTFL....

 

[Bob]

Arthur its working good but now I have a drop down list that shows me all my
horses in active Mode so now when they leave qryOrderByHorseName and go into
tblInvoice_ItMdt I lose them off this dropdown list untill they appear again
in qryOrderByHorseName. Its a Combo box using the same Query, How can I get
around this....I am very much appreciated for you help on
this........regards Bob

 

[Bob]

This is the code in My ComboBox drop down list maybe something added to it:
To show Horses that are in tblInvoice_ItMdt as well

SELECT tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,false) AS
Name, [StableReturnDate]
FROM tblHorseInfo
WHERE Status LIKE 'Active*' AND
tblHorseInfo.HorseID NOT IN
(SELECT HorseID FROM TblInvoice_ItMdt)
ORDER BY funGetHorse(0,tblHorseInfo.HorseID,true),
funGetHorse(0,tblHorseInfo.HorseID,false);

Thanks Bob

 

[arthurjr07]

you can use requery but you have to do it in VBA,

like this.

Me.Combo0.Requery

 

[Bob]

YEAH I did it , I made a new Query Name using your code an assigned it to
that List Box , Brilliant Thanx

 

[arthurjr07]

good job

Bye my friend, its already late in the evening here.
I have to go home.

Arthur