'#deleted' problem...

[Samball]

I have a problem which is bugging me for some time now...
I converted a MSAccess database to mySQL database.
Now when selecting from a combobox, (which is linked to a
table called [users]), a userId, i am doing a refresh in
the code , (DoCmd.DoMenuItem acFormBar, acRecordsMenu,
5, , acMenuVer70) , to write the data that came up when
selecting that userId to another table called [Problems].
Just after the refresh, it writes the data to the
[problems] table but the combobox and all the other Edit
Boxes which were filled with data from selecting a userId
now reads "#Deleted". Some where I lost the connection
with the data base I guess.
Anyone know where the problem might be?

Thanks...

 

[Tim Ferguson]

Some where I lost the connection
with the data base I guess.
Anyone know where the problem might be?

If this is all ODBC and ADO, then you may be better off trying one of the
ADO groups.

In your place, I think I would be doing all the data manipulation using
proper SQL calls and keeping track of the Connection objects -- using DoCmd
for managing data involves too much finger-crossing for my liking.

Sorry that's not a lot of help!

B Wishes


Tim F