Searching database problem

[Garrity]

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???

[raicheman]

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.

[Garrity]

OK.. Thanks for the help!