I have a query with two tables that are connected through a left join. The query provides data to a sub-form. The main form show information about an order, and the sub-form show the line items for the order. I am looking for a way to add a calculated field that would show the record number for records generated by the query. If the number of a record matched the absolute position I am on in my record set, or the number of the form's current record minus one, I could use conditional formatting to highlight the record I am on. Any thoughts on how to do this?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.