Value list values in form not saved in tables

Lou-Lou-Bell

Registered User.
Local time
Today, 08:10
Joined
Dec 30, 2014
Messages
15
I created a form with subforms that are all linked to their own tables. Values that are entered in to the form (i.e. just numbers or names) all save into the tables as I would expect; HOWEVER, all of my value lists (0,1,2 or 1-5) do not. I can change the values in the forms and as long as I am toggling between them they appear in the form but they are not populating the tables.

I would VERY much appreciate some help on this.

Other details. They are defined as numbers in the property table, I did change them to a value list in the form properties and did assign values to the property list.

I looked through some other threads that seemed similar but the solutions didn't apply. Because the straight up data entry saves, I feel like it is something specific to me creating those value lists...:confused:
 
Is the control source for the list set to a field in the table?
 
Yes it was. Turns out I should have been using a combo box instead of value list. I can't believe how hung up one can get on such a silly little misunderstanding. Gosh...
 

Users who are viewing this thread

Back
Top Bottom