Thanks to you guys I have the form working, the colors the way I want in the grid and the horizontal scroll working but since I added the error message if there was not a hit on delivery # back in, I am having problems. I spent the last hour playing and can not figure out how to solve it.
Here are the 3 problems problem in the jpg.:
Here is the code I have in #1 (txt_Search_deliv). If I uncomment out the "ThisForm.txt_Search_deliv
, I get an error that says: "Cannot call SetFocus from within a When, Valid, RangeHigh or RangeLow event."
If NOT Empty(ThisForm.txt_Search_
Set Filter To label.deliv_num = AllTrim(ThisForm.txt_Searc
IF NOT FOUND()
Messagebox("No records found for the entered Delivery #, please try again.",0, "Assign Tracking Numbers")