Solved: Problem with form - Name keeps reapearing

[NY2DR]

Hello all,

I have a little problem with my form in this database I am trying to create.

In the form "1New Hire Training Tracking for Month", when I change the date on the dropdown box from 6/11/2008 to 3/11/2008, I get the results I want.

when I change it back agian to 6/11/2008, I also get the results I want.

The problem becomes When I change the date and close out of the form, ABE LINCOLN's name keeps coming up.

If you were to open the form right now, the date is set to 6/11/2008.
ABE LINCOLN's name is there.

Change the date to 3/11/2008, and all the other names will appear. You will not see ABE LINCOLN.

Now closes out of it and open it up.
Viola! ABE LINCOLN's name appears!:eek:
This keeps happenning everytime the date is changed.

What little parameter did I overlook to prevent this??

P.s. It seems that whatever name is on top, it keeps happening. Any solutions??

Thanks.

[OBP]

If you make your Combo Box (Start Date) Unbound, when you open the form there will be no records displayed until you select one.
Will that work for you?

[NY2DR]

Yes! That does work for me!
Thanks! (I hate it when solutions are that simple!)

Quick question though.
I would like the Start Date to display the MAX DATE when it opens up.
What would be the best way to do it without ABE LINCOLN showing up again.

The last question is; why must the combo box be unbound for this solution to work?

Thank you oh so very much!!:super:

[NY2DR]

Ok,

I have the start date displayed to the MAX Date by using the Forms control - On Open, created an event procedure in VBA as "Start_Date = DMax("[start date]", "[1New Hires Database]")"

It is working very well. I would just like to know if it is the correct thing to do or if there is a more efficient way.

Also, to rephrase my last question from the post above,
Why must the combo box be unbound for this solution to work?

thanks