How can I 'unpopulate' a list or combo box for a NEW record in a f

  • Thread starter Thread starter Pickymiss
  • Start date Start date
P

Pickymiss

I have a form and will need to have users input data for numerous people.
When I select "new record" the choices that the previous record had are still
showing in the boxes. They are NOT in the table, but it looks confusing
because all the "answers" are filled in on the screen.

I have changed from list box to combo box... the result is the same. I must
be doing something wrong!

How do I make a new record appear as completely BLANK and ready for data?
 
I have a form and will need to have users input data for numerous people.
When I select "new record" the choices that the previous record had are still
showing in the boxes. They are NOT in the table, but it looks confusing
because all the "answers" are filled in on the screen.

I have changed from list box to combo box... the result is the same. I must
be doing something wrong!

How do I make a new record appear as completely BLANK and ready for data?
Click to expand...

What are the Control Sources for these fields? It sounds like you're using
unbound (blank control source) combo boxes, which means that the selection
isn't being stored anywhere - not much use!

More context please!
 
The choices are stored in a table (T_SocioeconomicRanking) and when chosen on
the form for a record, the values are stored in the table
(T_SocioeconomicWell-Being).

Unfortunately, when I choose "somewhat" for record 1 then move to a new
record (which should be completely blank) for entering record 2, "somewhat"
appears in the box... The field in the table (T_SocioeconomicWell-Being) is
not populated, but it appears in the form. It looks confusing (The data
entry person may wonder: Is it really there? Isn't it?) without opening the
table, there is no way to see if it is actually the new record's choice, or a
"legacy" choice from the previous record.
 
Back
Top