I'm stumped, help with database

Ok this is going to be kind of long...so if you are not into this stuff you may want to turn away now.

I am desinging a database right now on access 97. Here is what I need help with. I have a form set up to input vehicle information. It is a database to keep track of how many tickets specific licese plates recieve. Now the thing is after the vehicle has 5 tickets I need some kind of flag or box to pop up and aware the person that this vehicle has recieved 5 or more tickets. i had figured i would add a command box to the form which would allow the user to save the record and search through the table. If the vehicle has 5 or more then a new box would pop-up stating.....this vehicle has # of tickets..what would you like to do.....view report.....print report......skip to next record.

I am not sure exactly how to do this. I figure i could run a macro, or a query.....but im not sure how to get a new box to pop up when it needs to and have seperate command boxes inside that box....

if you can understand what i say, please help.......

You would be better off asking this question in the Access forum.

Well you might have something like a =DSum() in a field to show the number of tickets. And perhaps have code behind the form's OnCurrent to change the color:

' Set color based on num.
If Nz(txtNumOfTickets) >= 5 Then
' Red.
txtNumOfTickets.ForeColor = 255
Else
' Black.
txtNumOfTickets.ForeColor = 0
End If