I have a large database called main which has a column called exchange_rate. I have a form to input data in this main database called ministry_input. In my ministry_input form there is a combobox name Combo62 which pulls from a table called Exchangerate for the values to be saved in the main database for the record being input. I need the default for the combobox to be the last entry (one with the highest key value) in the Exchangerate table.
Private Sub Combo62_Click()
Private Sub Form_Load()
With Me.Combo62
.Value = .ItemData(.ListCount - 1)
End With
End Sub
This is what I have the problem is on the form it shows the correct value from the table (the exchange rate with the highest key value) but in the table it puts the key value instead of the value in the "Exchangerate" column. Help plz!