Re: Access AutoiNumber Fields

2000-08-03 Thread Steve Wach
n the insertion. SELECT MAX (ID) FROM tbExamble WHERE Value1=#Form.Value1# AND Value2=#Form.Value2# where value1 and 2 where the items added in the insert statement. This isn't perfect but it will select the highest Autonumber where the values are equal to that of the insertion. Steve

Re: Dynamic

2000-08-14 Thread Steve Wach
Try this, it's worked for me in the past This should give inputs Qty1 to Qty6 with the values past from the previous page. Hope this works. Steve Wach Software Engineer Canadian Web Design & Consulting Inc. A: 701-281 McDermot Avenue (McDermot