1st box<2nd box etc, In forms 
Author Message
 1st box<2nd box etc, In forms

I need help, is there a way to set a input mask or something to make
sure that the time in box 1 is less than box 2 and so on.

I.E.
08:00
08:10

Not
08:10
08:00

Please help.



Wed, 25 Oct 2000 03:00:00 GMT  
 1st box<2nd box etc, In forms

Hi,

You wouldn't want to use an input mask for this.  Use the Validation
Rule.  For example, in box 2 put

Quote:
> [ControlNameForBox1].

A more useful and flexible way to do this is with the AfterUpdate event
of Box2.  For example:

If Me! [ControlNameForBox2]<Me! [ControlNameForBox1] then
MsgBox("The time in this box MUST be later than the previous box.")
DoCmd.GoToControl "ControlNameForBox1"
End If

Hope this helps!!

Brenda

Quote:

> I need help, is there a way to set a input mask or something to make
> sure that the time in box 1 is less than box 2 and so on.

> I.E.
> 08:00
> 08:10

> Not
> 08:10
> 08:00



Wed, 25 Oct 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. 1st box<2nd box<3rd box?

2. Requerying 2nd combo box after change to 1st combo box

3. Calendar control 1st tuesday, 2nd thursday etc.

4. Displaying Day as 1st, 2nd, 3rd, etc.

5. Postions - 1st 2nd 3rd 4th etc

6. Linking / querying a 2nd sub form using the main form and the 1st sub form

7. Write to 3 combo boxes based on choice in 1st Combo Box

8. 2nd form's DoEvents pauses 1st form's DoEvents

9. Close 2nd form and return to 1st form

10. 3 Dialog Boxes - Skip 2nd Dialog Box when EditBox >10


 
Powered by phpBB® Forum Software © phpBB Group