Hi Darrenw,
If you are using ADO! When you define your ADO control make sure you have your record source defined under ADOCDC properties. i hope that this helped, email me if you need and example.
Bye,
Jim