I've opened a new database and dumped all the files/tables/queries in it because the original file had gotten corrupted due to the amount of queries that had been run. This fixed the problem.
I created a form with a choice box which takes you to a input form to put in order numbers for that choice. It works fine but when you close and choose the next choice the input form says "Cannot find Field" and i have to do a hard close to get out of that message box loop. Open the program...
Thanks so much. It is a expression that will allow me to pull changes in itineraries. I finally figured it out and transposed the expression and it worked.
Go figure Access is not a easy program!!
Thanks!
LB
Does anyone know how many characters can be used in a expression?
Mine is not working....it has 126.
[ASS_Cini2]![Itin_Date]=[Forms]![Cinci_Itinerary]![Itin_Date] And [ASS_Cini2]![Itin_Date]=[Forms]![Cinci_Itinerary]![KFM_Name]