display msg box

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

Hi
I have a field where the user selects letter D P OR C
which denotes the priority of the order. If at a later
date the priority is upgraded then D*, P* or C* are input
to show that it has changed. Is there any way I can
display a msg box to tell the user to change the order
date when D*, P* or C* are selected

regards steve
 
May I suggest the following:

1. Create a table called 'tblPriority'.
Field1: PriorityID (autonumber)
Field2: Priority (text)
Field3: Upgraded (yes/no)

2. In the table, put the following

Priority Upgraded
-----------------------------------
D False
D* True
P False
P* True
C False
C* True

3. Use a combo box for the user to make the selection. (call it cboPriority)

4. When its a normal selection, set the rowsource to:
cboPriority.RowSource = "Select Priority From tblPriority Where
Upgraded = False

5. When its an upgrade, set the rowsource to:
cboPriority.RowSource = "Select Priority From tblPriority Where
Upgraded = True

When you know that its an upgrade, don't save the record until the user
selects an entry from the comb box.

Oh yeah, set the limit to list property to TRUE

HTH
--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Shouldn't you do this the other way around? Change the order date, which is
what the user will probably be doing first, and it will automatically change
the priority based on your rules... In any case, place the following in its
AfterUpdate event...

If Right(Me![TextBox], 1 ) = "*" Then
MsgBox"Don't forget to change whatever!"
End If

HTH

Tom.
 
Thanks for the info, but still need to let the user know
that they need to change the date the order was placed if
it is a D*, P* or C*. I should have said in the orginal
message that they change the date of the order to the
date it is upgraded.

regards Steve
 
Back
Top