Thanks for the code.

Yes I am using DAO with VB5. Your assumption is correct.

I removed the Databasname value fom the Properties window of the Data Control.

I added the following line to my main form which contains the DBGrid, PARTS being the name I gave the conrol. I added this within the Activate() event.

Me.PARTS.DatabaseName = App.Path & "\PARTS.mdb"

After running this program I get the error:

>Run time error 91

Object variable or With not variable not set
<

Did I do the above correctly?

BTW - Sorry about the CAPS LOCK.