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

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?
 
J

John W. Vinson

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?

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!
 
P

Pickymiss

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top