-
Ive got a little problem...
when i use the command
ex: data1.Refresh
my whole databse system kind of locks up...
the DataControl wont react to clickking and the only thing that works is the buttons...
(About and that sort of stuff)
I also got a kind of search button that
uses this command
Dim CompName As String
data1.RecordSource = "select * from BLABLA where BLABLA = '" & BLABLA & "'"
This works also until the command data1.Refresh is loaded!
WHYWHY???
-
The data1.refresh is the commands that changes the database. The recordsourc does not take effect until the refresh command is executed.
If the source is a complicated sql or if the database is very large it can sometimes take a few minutes for the databse to refresh. This can also be effected by whether you are opening the data as a dynaset or snapshot.
-
OK.. Thanks for the help!