Combo select - precheck control

[GUIDO22]

Hi
I am looking to run a query on selection / keyed entry of a numerical value in a combo dropdown.

The query returns a small recordset to the VB code that is analysed for a flag value. This value determines the value of a check box on the form.

(for those interested : .....The form is a PrintInvoice form - the dropdown is for the specific invoice number, when this has been entered I need to determine if the client has pre-paid for all the orders against this invoice in which case a 'PrePayment' check box is set to True. This displays the appropriate notification on the invoice when the form is printed).

The problem I am having is where to call this code from?

If I use the Dropdown Lostfocus() or Exit() events - the code runs when the form is loaded and when the form closes..... and if I use the Change() event, each keypress in this field causes the event to fire...

Is there a cleaner way to do this or will I have to use form load flags to determine if the form is either loading or closing to avoid the recordset retrieval code from being run?

Thanks in advance for any help.

Regards
G

 

[HiTechCoach]

I would use the After Update event of the combo box.

 

[GUIDO22]

Thanks but I thought that event only fires if the field is a bound control - which it isn't.....

 

[HiTechCoach]

Thanks but I thought that event only fires if the field is a bound control - which it isn't.....

So the lost focus event did not work either?

 

[gemma-the-husky]

a combo box will fire an after update whether its bound or not

try it and see

 

[GUIDO22]

Well played Gemma - didnt realise that - works a treat- THANKS!