I have a quick question regarding VBA for a Form. I have the code below in the OnCurrent event of a form i'm using but i'd also like to add another piece of code which simply requeries a combo box but i get an error saying something about an ambiguous name ?
The following code works fine
Expand|Select|Wrap|Line Numbers
- Private Sub Form_Current()
- Me.txtLast.DefaultValue = Format(Nz(DMax("CalibrationDone", "tbl_CalibrationRecords", "EquipID = '" & Me!EquipID & "'"), Date), "\#mm\/dd\/yyyy\#")
- End Sub
Expand|Select|Wrap|Line Numbers
- Private Sub Form_Current()
- Me.Combo52.Requery
- End Sub