help with a form? plz?!

[alexi]

i want to get a thought of the day text box on my switchboard
i have put them into a table labelled tblThoughtOfDay
now each time i open the switchboard, i want it to randomly select one of the thoughts and display it?
how do i do that?! ive tried and tried and cant figure it out

ta

 

[Oldsoftboss]

Heres a start
Dave

 

[Oldsoftboss]

How is sunny WA anyway ? I have a brother and sister in law in Perth & they think it's great
Dave

 

[alexi]

thanks very much for that mate. it worked a treat!
yea sunny WA is mint at the moment. today may be a bit hot though, 35. thats not to bad though

TA

 

[Oldsoftboss]

Dry everywhere, but,

Glad the zip helped.
Dave