I have a Main Survey form which a user can add a new record then enter data and then click to the next form to fill out the next form data for the same record (which contains subforms); they are linked by the same record # field called (AS Record#) but say i'm at record # 24 on the main survey form page and then click to next form it doesn't set to current #24 record. I have to flick thru records to get to # 24
My question is: Is there a way to set forms so it stays/brings up whatever the current record number was on the last form you were on or if you change to form two and go to a different record then flick to the next/ 3rd page it'll recognize what the current record is and bring up that record upon entering the next form?
Hope I didn't sound too confusing?
THANKS
My question is: Is there a way to set forms so it stays/brings up whatever the current record number was on the last form you were on or if you change to form two and go to a different record then flick to the next/ 3rd page it'll recognize what the current record is and bring up that record upon entering the next form?
Hope I didn't sound too confusing?
THANKS