I have created a form with several txt boxes having their control sources set to a cbo box. I did this so all related info. could be pulled and displayed in the txt boxes for a given job # selection in the cbo box. By setting the control sources to the cbo box the information diplayed in each txt box is not then added to my associated table. I need all the related information displayed in the txt boxes to then populate my table. Is there some additional code I need to write or a simple check box option I'm missing? Please help!
Yes, I understand that is an option. I have used that route in the past. However, doing it that way creates more work and room for entry/selection error (selecting related information in several cbo boxes as apposed to having txt boxes automatially pull related information from a query based on a cbo box selection - no error). I'm trying to make this very user friendly. I need to map the txt boxes back to the my table for each new record.