Simple question but I can't find the answer:
I have a continuous form which I created using the wizard.
The form has three fields: VehicleNum, ODate and Odometer.
In the header of the continuous form, I changed the VehicleNum to a combo box that filters my the form by VehicleNum. (So it displays all records for the selected Vehicle). Code is below
What I want to do now is keep the remaining bound text boxes in the header blank instead of displaying the last value in the continuous form
I have a continuous form which I created using the wizard.
The form has three fields: VehicleNum, ODate and Odometer.
In the header of the continuous form, I changed the VehicleNum to a combo box that filters my the form by VehicleNum. (So it displays all records for the selected Vehicle). Code is below
Code:
If IsNull (Me!cboVehicleNum) Then
Me.Filter = ""
Me.FilterOn = False
Else
Me.Filter = "[VehicleNum]=" & Chr(34) & Me.cboVehicleNum & Chr(34)
Me.FilterOn = True
End IfWhat I want to do now is keep the remaining bound text boxes in the header blank instead of displaying the last value in the continuous form
