|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 10th, 2008, 08:36 PM
posted to microsoft.public.access
|
|||
|
|||
How can I 'unpopulate' a list or combo box for a NEW record in a f
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? 
|
|
#2
December 11th, 2008, 12:34 AM
posted to microsoft.public.access
|
|||
|
|||
|
How can I 'unpopulate' a list or combo box for a NEW record in a f
On Wed, 10 Dec 2008 12:36:01 -0800, Pickymiss
wrote: 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! -- John W. Vinson JVinson *at* Wysard Of Info *dot* com
|
|
#3
December 16th, 2008, 06:39 PM
posted to microsoft.public.access
|
|||
|
|||
|
How can I 'unpopulate' a list or combo box for a NEW record in
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. "John W. Vinson" wrote: On Wed, 10 Dec 2008 12:36:01 -0800, Pickymiss wrote: 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! -- John W. Vinson JVinson *at* Wysard Of Info *dot* com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
