X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> How To Compare 2 Fields Alphabetically?, Access 2016    
post Feb 15 2020, 09:01 PM

Posts: 206
Joined: 23-January 05

I have 2 combo boxes, "Equipment 1" and "Equipment 2" on a bound data entry form.

The Row Source of both combo boxes is from a single "Equipment Lookup" table. Is there a simple way to flag to the user who is entering data if the "Equipment 2" entry is "earlier" alphabetically than "Equipment 1"? I would want this to happen on the "After Update" event of "Equipment 2".

So....if "Dozer" is entered into "Equipment 1" and "Grader" is entered into "Equipment 2", the user can proceed. But if "Grader" is entered into "Equipment 1" and "Dozer" is entered into "Equipment 2" a message box would appear alerting the user.

I've been Googling this for hours and have found nothing. Hopefully it is relatively simple.
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    25th May 2020 - 03:39 PM