"Value List" Data Removed When Data Is Enter In A "Text Box"

lhooker

Registered User.
Local time
Today, 18:42
Joined
Dec 30, 2005
Messages
423
I'm using the "Value List" as the "Row Source Type" and data in the "Row Source" in a form. The data in the "Value List" is used in a "List Box" of this form. Also this form has a "Text Box" that is used for a date (in the "Short Date" format). When I select values from the "List Box", then enter a date in the "Text Box", the values from the "List Box" are unselected. How can I determine what is causing this ?
 
Last edited:
That could be almost anything. Care to post a stripped down version of your db that demonstrates the problem?
 
RG,

Here ya go . . . a zip file (i.e. "Test.Zip") is attached . . . follow this order to reproduce the problem. Select a teacher from the "Listbox", select three or four values from "Written Descriptive Evaluation Remarks:" section, select values from "Recommendation Of Evaluation" section, place one check mark for each line item in the "Yes No N/A" section, then enter a date in the "Visitation Dates" section. You will notice that when you enter the first numeric value of the date, the selected values in the "Written Descriptive Evaluation Remarks:" and"Recommendation Of Evaluation" sections are removed. Thanks for your help ! ! ! ;) ;) ;)
 

Attachments

Last edited:
Believe it or not, it did exactly as you described the FIRST time I ran the form. Now I can't get it to do it again. Go figure. I'll keep playing with it.
 
Has anyone else experienced this ? Is there a workaround for what I'm doing ?
 
As a follow up, it only does it when there are no records in the [selected] table yet.
 
You're welcome but I still can't figure out why it is happening.
 
Hi lhooker,
I still haven't pinned down the problem but I noticed a lot of code in the form that was not being used. I'm sure it was put in to try and pin down the problem. Access can be quirky on occasion so I was wondering if creating a new form from scratch without any unnecessary code would make the problem go away. I already tried a /decompile without success. Just a thought.
 

Users who are viewing this thread

Back
Top Bottom