Search Combo box malfunction

[babak.nourani]

Hi,

I have a Main form with a Combo box. I created the Combo box by wizard to find a record in that form.
I works perfectly.

I have another form with a button. When the button pressed the Main form for a specific record will open.
It works perfectly too.

The problem is whenever I jump(by pressing the button) from the other form to the Main form the Combo Box does not work anymore. It does not search and pick up records.

When I close the Main form and open it again the problem disappears.


It seems that it just does not work when I jump from the other form to the Main form. But when I open the Main form directly it work perfectly.



Would you please consider this,
Thank you.

[pbaldy]

How are you opening the main form from the other form? It sounds like you're opening it with a wherecondition, so it would only have those records available.

[babak.nourani]

Yes, it is a where condition.
Is there any way to make it works?


Regards.

[pbaldy]

I have heard that you can "remove" the wherecondition with

Me.FilterOn = False

Try that and see if it works.

[babak.nourani]

Where should I put the "Me.FilterOn = False"?
Beside the where condition?

Regards.

I have heard that you can "remove" the wherecondition with

Me.FilterOn = False

Try that and see if it works.

[pbaldy]

Well, you've opened the form filtered to a given record or records, so at whatever point you want to open the form back up to all records. Perhaps in your combo code before it searches for a record. You might also consider this method of opening the form:

http://www.baldyweb.com/Bookmark.htm

[babak.nourani]

My Where condition is ="[Com_Name]=" & "'" & [Com_Name] & "'"
would you please tell me in my case what would the new code should be?



Regards.

Well, you've opened the form filtered to a given record or records, so at whatever point you want to open the form back up to all records. Perhaps in your combo code before it searches for a record. You might also consider this method of opening the form:

http://www.baldyweb.com/Bookmark.htm

[pbaldy]

Your value is text, so the variable would have to be declared as String, and the FindFirst value would need to be surrounded by single quotes, just like your wherecondition.