Form locks itself (1 Viewer)

mcdhappy80

Registered User.
Local time
Today, 18:15
Joined
Jun 22, 2009
Messages
347
[Solved - Kind of] Form locks itself

I recently made some changes to my code and now I'me experiencing a problem when I execute that code the previous form (which is the applications main menu) locks itself and I cannot close it and none of the buttons are working.
The new piece of code that I added is this:
Code:
Forms![frmZaduzivanje_NSG].recordSource = "qryZaduzivanje_RecordSource_NSG"
So basically what I'm doing is changing the record source of the form I'm currently in via the combo box, and that causes previously opened form to lock.
Can someone please explain why, and is there a solution to this problem?
Thank You.
 
Last edited:

mcdhappy80

Registered User.
Local time
Today, 18:15
Joined
Jun 22, 2009
Messages
347
Bah, since no one answered and I'm in a hurry for a solution, I've solved my problem in a different way. :)

I tried to avoid form filters and use query defs only but it seems this cannot work this way, so I rid of the need for two queries as forms data source, and am using only one, and I apply a filter if needed.
 

vbaInet

AWF VIP
Local time
Today, 17:15
Joined
Jan 22, 2010
Messages
26,374
Let's see your db and tell us the problem form with steps to reproduce the problem.
 

Users who are viewing this thread

Top Bottom