By "TREAT" I ment to work on it, to do something with it.
And Yes I have a continuous form view that looks like this:
[] partOne descriptionOne
[] partTwo descriptionTwo
[] partThree descriptionThree
[] and so on,
[Back button] [Done button]
I usualy have more then ten records. What I have now is I get all the selected records but the current one. There must be a way of forcing Access to save the info of the current record.
I want to be able to circle throught the selected records, check the part number and do diffrent things depending on the part number. Right now, if there's only one record selected, I get an error message that there's no record using "MoveLast" to get the recordcount. I'm using a SQL statement to open a dynaset in order to modify some of the records found. Here's what I have
Set db = CurrentDb()
strSQL = "SELECT * FROM tblPartNo WHERE Delivered = -1"
Set tblPartsOrdered = db.OpenRecordset(strSQL,dbOpenDynaset)
tblPartsOrdered.MoveLast
If Not tblPartsOrdered.NoMatch Then
Do Until tblPartsOrdered.EOF
'Do what ever I need to do here
If I have three records selected, recordcount = 2.
Am I making more sens? How would you do it? I can start all over if there's a much better way. I can't be the first one who tries to design this type of form.
Thanks