Help with a procedure someone from this site sent me

[GeraldJ]

A procedure is set to do the following on a command button..
NewDataPath is selected from a combo box showing all the folders containing the appropriate .mdb

frmChecks.tblChecks.DatabaseName = NewDataPath

frmChecks.tblShowGL.DatabaseName = NewDataPath

frmChecks.tblCheckPayTo.DatabaseName = NewDataPath

frmChecks.tblGLTransaction.DatabaseName = NewDataPath

frmChecks.tblEditTransactions.DatabaseName = NewDataPath



using msgbox I have looked at it before I change it and it’s the unchanged name

using msgbox I have looked at it after I change it and it is the new name.



However, when attempt to enter checks it does not put them in the new database but in the default.



It is am application where I create a folder for each client and within that folder I have the database that I want to use.



Any help would be greatly appreciated.

 

[tedsmith]

maybe you have to refresh or requery something after you change the name?

 

[RickyLee]

I'm sure I can help you with this, but this is not enough information. Could you provide more info? Thanks.

 

[GeraldJ]

Thanks for your response....had tried the refresh but will try the requery.