VBA Me. Code Problems

[beaverx37]

Name: VBA Code 1.png  Views: 12  Size: 121.0 KB  ID: 19655" class="thumbnail" style="float:CONFIG" /> I have two problems, my first one is I am trying get Me.CamperIdNum It was originally named CamperID# but I was having problems getting it to work so I changed it and it changed everywhere else in my database except here. Is there a way to fix that?

Second is I am trying to get Me.GoToBox.Value = Me.CamperIdNum.Value
GoToBox is my combo box that allows you to select a specific record and CamperIdNum is my primary key.

The goal is if I select a record by using the previous and next record buttons, I want the combo box to respond and change to the record that is displaying. I keep getting this error though

I don't know very much about code so you're explaining to a beginner

Thanks!!

[June7]

Something somewhere still has the old name. Verify names of controls on form, start with whatever CamperIDNum is supposed to be referencing.

I use Rick Fisher's Find & Replace for Access to track down this sort of issue. Saved my sanity more than once. Cost about $50. A freebie called V-Tools has good reviews.

[amrut]

While in VBA window press Ctrl + F to bring up the standard Find & replace window and use it to replace the code. You can selectively find/ replace in a procedure/module or entire project.

[June7]

That will not search in properties of objects and controls. Require 3rd party app.

[amrut]

I have two problems, my first one is I am trying get Me.CamperIdNum It was originally named CamperID# but I was having problems getting it to work so I changed it and it changed everywhere else in my database except here. Is there a way to fix that?

I was trying to help OP to resolve the above issue.

[June7]

I think they did the search/replace in VBA code and the remaining issues are due to something (textbox, combobox, fieldname) still has the old name. The 'not found' error tells me the control still has the old name. Access does not have any tool for search/replace in properties.

[beaverx37]

It finally updated on its on, thank you! And the code worked just fine this time