I’m trying to add a dropdown on a form to add information to separate reports.

[SJones2104]

I’m trying to make a dropdown box in a form then what that person selects when they close the form it will save that to a table but I just can’t get it to work. Any help is greatly appreciated!!

[GKJR]

The form needs to be bound to the table that you want the data saved in. In design view, under form properties and in the data tab, select the record source to be the table you want to update. You can also update records from a query if your relationships are properly set up. You then need to set the control source of each control to match the field they will be linked to.