Can I put multiple lines in the Expression Builder?

[liamlaurent]

Hello All,

I want to change the ROW SOURCE value of a combobox on a form dynamically. I want to requery it also when it is changed. Can I accomplish this in the Expresssion Builder without have to use VB code?

Thanks
Liam

 

[LonnieJohnson]

No. This will have to be done with VBA. VBA is not that bad.

Let us know what event will trigger the changing of the rowsouce and we can help you.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[liamlaurent]

Thanks for the response. I am familar with VB so I will just use the event handlers then. The reason why I asked is because I did not want to complicate this with VB as it is for a novice class in ACCESS. Thanks anyway.

Cheers
Liam

 

[LonnieJohnson]

Ohhh. I understand.

Didn't mean to talk down to ya. There are many who prefer macros for everything in an attempt to avoid learning vba.

Good luck.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[liamlaurent]

Thanks again Lonnie.

Liam