Khoi
02-07-2002, 09:57 AM
Hi all,
I have a form where I get my records from a customized SQL that I built. On this form, I also have 2 customized button to act as next/pre record. The form is in snapshot mode. What I would like to do is while allowing my user to browse through all records that belong to a particular customer, he/she can just stop at any record and update the information on that particular record.
I have tried to use:
me.recordsettype = 0 - which set it to dynaset
then use
DoCmd.GoToRecord acDataForm, "FrmPledgeRecordsMgnt", acGoTo, 156 to see if it let me to do the update but I always get error 2105 with description of "you can't go to the specified record". Can someone shed some light to my problem please.
TIA
-KN
I have a form where I get my records from a customized SQL that I built. On this form, I also have 2 customized button to act as next/pre record. The form is in snapshot mode. What I would like to do is while allowing my user to browse through all records that belong to a particular customer, he/she can just stop at any record and update the information on that particular record.
I have tried to use:
me.recordsettype = 0 - which set it to dynaset
then use
DoCmd.GoToRecord acDataForm, "FrmPledgeRecordsMgnt", acGoTo, 156 to see if it let me to do the update but I always get error 2105 with description of "you can't go to the specified record". Can someone shed some light to my problem please.
TIA
-KN