data find combo box problem

[mike60smart]

You need to go into the properties of the Form and click on the All Tab
Scroll down thew list and set Record Selectors & Navigation Buttons to Yes

[Welshgasman]

When you use the frmOfferRegister to select a specific record your are applying a Filter to the Form for that selected Record.

Why can't you use FindFirst?
Also just remove filter if you insist on using one, when you click the button for offer entry?

[deepaksharma]

You need to go into the properties of the Form and click on the All Tab
Scroll down thew list and set Record Selectors & Navigation Buttons to Yes

No, I don't want the navigation bar to be visible on the form. How will this happen

[deepaksharma]

Why can't you use FindFirst?
Also just remove filter if you insist on using one, when you click the button for offer entry?

Yes but I want the filter by default to remain removed and the navigation bar should not be visible in the form.

[mike60smart]

Well as Welshgasman has already suggested in the On Click Event to open the Form frmOfferEntry use

Me.FilterOn = False

[deepaksharma]

Well as Welshgasman has already suggested in the On Click Event to open the Form frmOfferEntry use

Me.FilterOn = False

Thanks it working....

[deepaksharma]

Why can't you use FindFirst?
Also just remove filter if you insist on using one, when you click the button for offer entry?

Thanks to both of you, my problem has been solved with this code.
Me.FilterOn = False
I understood what you said from the code suggested by Mike but I did not understand what find first you were talking about, please explain.

[Welshgasman]

Instead of filtering to a record, you can just locate it with a FindFirst. Just a different way to approach the issue.

[deepaksharma]

Instead of filtering to a record, you can just locate it with a FindFirst. Just a different way to approach the issue.

can you tell me its code

[Welshgasman]

Google it. You cannot expect everything to be handed to you on a plate. You will learn nothing that way. :-(

[deepaksharma]

Google it. You cannot expect everything to be handed to you on a plate. You will learn nothing that way. :-(

Ok, I will work hard again.

[Welshgasman]

Hardly hard?
If you are not prepared to put in any effort, you will likely find you get less assistance?

[deepaksharma]

Hardly hard?
If you are not prepared to put in any effort, you will likely find you get less assistance?

What I mean to say is that sir, I am already quite entangled in one and the other coding and I am not able to find the solution. "Ms access unload form event for stop autosave data"

[Welshgasman]

https://learn.microsoft.com/en-us/of...rst-method-dao