Unexpected Default Values on Form

[Judi]

I have a form that we use to keep track of quotes. Lately, it has been acting
a little strange, and I would like some advice about how to go about fixing
it.

When you start a new quote in the form, it brings up a blank form. If you
start entering a number in the "QuoteNum" field, it brings up some data in
another field automatically. There is a DM field and an SSM field which both
contain information from the same table. One is a District Manager and the
other is a Sales Service Manager. Both are selected from a combo-box. The
combo box for SSM automatically pulls up one record and the DM box tries to
pull up the same information also. The record they are pulling is not the
first in the combo box and it's not the first alphabetically.

Does anyone have any ideas as to why this happens? I would like to set the
defaults to null or blank or whatever it needs to be so that these defaults
do not show up. What do you need to see?

Thank you to all who may help.

 

[strive4peace]

Hi Judi,

go to the design view of the form

look to see what events are defined in the Property sheet for the
QuoteNum control

to better understand how to decipher this and get to the code, read:

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

Warm Regards,
Crystal


*
have an awesome day
*