Hi I wonder if anyone can help..
i have this table...
TblQuote
when the user creates a new version i would like to know how to calculate and hide old records for a given QuoteNo (all except from the previous version.)
ie as version 3 is created hide version 1 (HideQuote=yes) so that only 2 records exists for each quote, the new and previous record (ver2 &Ver3) and if a 4th version is created hide ver2 and so on
calculating the the revision numbers was easy Me.QuoteVer = DMax("QuoteVer", "[TblQuote]", Me.QuoteNo) but hiding them..... ohhhhh
could i use the dmax?
i know there are good VBAers in our community, but this one for me is well over my head skill or knowledge of VBA (have been trying for several days on and off)
appreciate any comments, thanks guys.
i have this table...
TblQuote
QuoteID | QuoteNo | QuoteVer | HideQuote |
2107 | 2107 | 1 | No |
2109 | 2107 | 2 | No |
2111 | 2107 | 3 | No |
when the user creates a new version i would like to know how to calculate and hide old records for a given QuoteNo (all except from the previous version.)
ie as version 3 is created hide version 1 (HideQuote=yes) so that only 2 records exists for each quote, the new and previous record (ver2 &Ver3) and if a 4th version is created hide ver2 and so on
calculating the the revision numbers was easy Me.QuoteVer = DMax("QuoteVer", "[TblQuote]", Me.QuoteNo) but hiding them..... ohhhhh
could i use the dmax?
i know there are good VBAers in our community, but this one for me is well over my head skill or knowledge of VBA (have been trying for several days on and off)
appreciate any comments, thanks guys.
Last edited: