Requery a non pop-up form which is already open and maximize

[gstylianou]

Good morning again,



In my database i have a main form (such as switchboard form) and a lots of command buttons. One of them is the "cmdSearch" which can open the "frmSearch". When i use this command i can open the search form in order to find the customer. Then, i have embedded other command button which is responsible to run a code in order to find the customer from tblCustomers and then to open the "frmCustomers" which must match the CustomeID.

Everything working fine until the time to re-press the command Search again..! So, If you do that i must find a solution to make requery the frmCustomers which is already active..!!


Can somebody to help?

Regards

[ItsMe]

Have you tried
Forms!frmCustomers.Requery

[gstylianou]

Ye but i don't know i take back error...
please note that, the main from still active (tapform) moreover and the search form the same. The search form is a pop up form...Any idea?

[ItsMe]

Pop up should not make a difference. I do not understand the releveance of the search form. Requery will requery a form's current recordset and include any filter properties within said requery. If you need to adjust the filter properties or RecordSource of the form, do so before Requery.

If you have a Modal and Pop Up form then maybe

Me.Modal = false
Forms!frmCustomers.Requery
me.modal = true

or
Me.Modal = false
Forms!frmCustomers.setfocus
Forms!frmCustomers.Requery
docmd.close acform, Forms!PopUpFormName

[gstylianou]

I will try to attach a sample in order to check it..By the way thanks for your direct response..

[gstylianou]

This is a sample.

Waiting your response

Regards

[ItsMe]

There are some issues with your DB. VBA is not recognizing your form as a form object. Also, there are other issues with your frmCustomers. For instance, the events are not firing correctly. Perhaps you changed how events are handled from saved Macros to VBA and back and forth again. I was able to correct a few issues but there are many issues with the first object I looked at, frmCustomers.

Recommend rebuilding frmCustomers. Could be corruption in other objects too. Perhaps rebuilding objects in a new DB is appropriate.

[gstylianou]

Dear friend,

First all i would like to thank you very much for the information you have given. But, I want to mention that I already carry all the database objects to a new access database and i have this results...... I don't know what i can do more..


Some questions:

1. VBA is not recognizing your form as a form object
Can i do something with this issue? I mean its necessary to write a code in order to vba to recognize my frm as an object?

2. For instance, the events are not firing correctly
Really i don't know why you find out this issue? If you mean that, there is no correct written commands by me, ok i understand because as i told from the beginning i don't have any programming experiences.. but if the problem is anywhere else on vba installation please let me know..

Thank you for your time.

Regards

[ItsMe]

The sample you provided me was corrupt. Nothing to do with the VBA per se.

Events in frmCustomers were not working correctly. By removing them, I avoided getting errors. The error indicates to me that you, at one time, had an embedded macro in the event property.

My assessment is that the file is corrupt. You may be able to salvage bits and pieces of your original DB. However, importing a corrupt form or even a corrupt control within a form could replicate the problem in a new DB.

[gstylianou]

Thanks again..i will see how can i fix the problems

Regards