Hello all. I have a quick question. I'm sure it's an easy answer and I am just missing something with this. I have a legacy 2008 MDB database that was converted over to a SQL server. Conversion went as planned and made the old Database a SQL front end. Linked the tables to the new SQL tables, all is working as intended.
The database is a very simple Cert of Calibration database. There are only three tables, Data, Equip and CofC Data. The Equip table holds the Equipment that is used for Calibration, the asset number and the Calibration Due Date. The Form used to enter the Cal data for our products has a ComboBox drop down and the user would select a piece of Equip and it would populate the fields in the form with the ID, Description, Asses and Cal Due Date. Whomever originally created the DB NEVER used the Equip table. Rather they coded the different pieces of Eq for the COmboBox as a Value List. This would have been fine but with 10 ComboxBox fileds, anytime the Cal date needed to be updated was a PITA. THus my idea to utilize the Equip table instead.
With the new Query, the data is getting pulled from the Equip table and populating all the fields on the Form EXCEPT the Cal Date field (CD10).
Here is the Code I am using for the On Change Event for Field ID10
Private Sub ID10_Change()
Me.Equip10.Value = Me.ID10.Column(1)
Me.Tag10.Value = Me.ID10.Column(2)
Me.CD10.Value = Me.ID10.Column(3)
The CD field is the only field not populating the data from the Equip table and not sure what I am missing.
Any suggestions would be grateful!