Use of 'requery' to requery a text box

[Corsica]

On the 'on change' event on another text box on my form called 'frmWIT2' I have put this line of code:

Forms![frmWIT2]![cmboStartDate].Requery

The combo box 'cmboStartDate' is requeried as required when I run the database file on my home computer, but when I run it on my laptop it does not work.

Any ideas would be appreciated!

Corsica

 

[PHV]

it does not work
Some error message? Unexpected result ?
What is the underlaying SQL code of cmboStartDate.RowSource ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Corsica]

Thanks for your reply, PHV.

Yes, it does not work. No error message.

The unexpected result is that....it does not work - despite the fact that the underlying SQL code of cmboStartDate.RowSource was not changed after the file was loaded onto the laptop.

I thought that the laptop may not have a particular DLL or other file that is necessary for the 'requery' to work.

-Hoping someone might know what file that might be. )

 

[PHV]

You may check the references:
when in VBE (Alt+F11) menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Corsica]

Thanks PH. I'll take a look at that.

And, to be fair, I can see now that writing 'it does not work' in the question wasn't the best thing.

I won't go into the details now as there seems to be no point. But later, if necessary, I'll post another better worded question.

Corsica