Fill in table fields from unbound textboxes in Access 2007 form.
Windows 10 
Access 2007
I do not know much about coding at all. I am able to do simple tables, forms, queries and reports. And put coding in if I know exactly what and where to put it. I have two tables. One is the Project table and the other is the Provider table. The below is of the Provider drop down box that comes from the Provider table that fills in the Project table field when a selection is made. The others are unbound fields that updates in the form after the Provider drop down selection is made. They are also actual fields that are in the Provider table that I need to fill in the Project table also. I do not know how to do this. I was hoping that you could help to know what code to put in and where to put it.
It will cut down on a lot of confusion and mistakes to only have to the Provider field drop down selection and let it put the necessary information in the other fields. However, it really does not do any good if it does not also update the project table fields. I need the information in the project fields to be able to export to Excel. I know that I can do reports with the unbound field information in it. But that information would not export to excel to my knowledge.
Checked Date: =[Combo90].[Column](4)
Provider: Provider
Area: =[Combo90].[Column](2)
Contact:=[Combo90].[Column](3)
Max:=[Combo90].[Column](5)
Min:=[Combo90].[Column](6)
Priced:=[Combo90].[Column](7)
Type:=[Combo90].[Column](8)
Private Sub Checked_DATE_Change()
Me.Checked_DATE = Me.[Combo90].[Column](4)
End Sub
Reply With Quote
Originally Posted by Delfina
