Using bookmark to go to form data using combo box

  • Thread starter Thread starter Andy G
  • Start date Start date
A

Andy G

Does this work in A2003?
AfterUpdate of combo
'Move to the record selected in the control Me.RecordsetClone.Findfirst
"[ID] = " & Me![ComboOrListboxName] Me.Bookmark =
Me.RecordSetClone.BookmarkI have a combo box that is bound to ID
(autonumber) field in my table. Whenever I click on that combo box and try
to change values I get an error in the status bar that says I can't edit
field; it's bound to autonumber field. This form is bound to a table that
has one primary key that is an autonumber. Thanks for the help.
 
Andy,

Normally you would use this kind of code on an unbound control, so you
can enter any value in there you like, which is then used as the basis
of your navigation from record to record. If you have a bound control,
you are effectively trying to edit the value of the data in that field
for the currently displayed record.
 
Back
Top