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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo on form in Datasheet view 3
Combo Box to look up autonumber field in a form 2
GoTo from combo on form 3
Combo Box error when Auto Number present 7
Selection from combo box doesn't fill text box 2
Combo Boxes - DISPLAYING multiple fields after choice is made 5
Combo Box question. 3
Format of SSN Field on Form 2

Back
Top