So I have a form where I want users to be able fill out some information and save it to a table.
The fields I have in this form are [Name] , [District], [Location], and [Title]
Name and Title are normal text boxes where the user can sinple type in whatever they want. However, District is a combo box and Location is a text box that is dependent on the selection of the District combo box.
I want to make it so that depending on what is selected in the Districts combo box, the Location field is auto-populated.
I'm able to do this by writing =Combo3.column(1) in the control source of the [Location] field.
However...When I go to the table, I see that all the other fields were saved except the [Location] field which was auto populated.
How do I get it to save in my table?? Ahh! Help!