Stop repeating entries from previous record

[Felitaj]

How do I stop entries from previous records from repeating n drop down list
when I create new record in form view.
For example: record one may have a field with a drop down list choice of yes
or no and I may select no, but when I create a new record all fields are
blank except for the drop down list with the choice of yes or no, it
automatically will display the entry from the previous record, for example no.

 

[Al Campagna]

Felitaj,
If you're saying that when you set the list value to Yes, all other
records show Yes too?

If that's the case, then the drop down list control isn't bound to a
table/query field.
An unbound text control, when a value is entered, will show that value
across all records.

For each record to be able to capture it's own Yes or No, it must be
bound to a table field, like a Boolean T/F.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."