chuckcoleman
Registered User.
- Local time
- Today, 05:30
- Joined
- Aug 20, 2010
- Messages
- 357
I have a continuous form. The form displays rows from a query. An important field is the WorkNbr, which is a number field. I need to find a way to display only one WorkNbr row if there is more than one WorkNbr in the Query. I can't use a Totals query because the user needs to input data into three other fields; PayAmt, CheckNbr and WorkDate. An alternative to filtering out a row in the query if there is more than one WorkNbr, would be to set the .visible property of a row to False if it was the second or more occurrence of a WorkNbr. Any ideas?