Limit Combo Box

E

Eddie B

I will do my best to make some since.
I have a form for entering data into a table named dispatchdetatils The
Combo Box named vehiclebox on the form shows vehicle license plates numbers.
When a vehicle is chosen a new record is started and the new record milesout
field on the dispatchdetails table is populated from the max of the milesin
field. Below is what I have in the After update of the combox.
What I would like to happen also is if there is a milesin field that is null
then do not start the new record but have a pop up appear stating the vehicle
is already out. Thank you in advance

Private Sub VEHICLEBOX_AfterUpdate()
If Not IsNull(Me.VEHICLEBOX) Then

Me.milesout = _
DMax("milesin", "dispatchdetails", _
"tagnumber = " & Me.VEHICLEBOX)


End If


End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Combo Box Question 2
Extract value from specific record to populate a new record 7
Is this possible? 0
DMax on existing record to increment serialized # fails 1
Displaying Inspection Due Date 5

Top