Wait for update (refresh not working)

In my database, I have set up a system to track switches and what is plugged on to each port. I have created a form based on the switch table query (refines it down to a specific office). All runs well except for the form I am using to make changes to the list of switches in an office. It's layed out like this:

There is a combo box that lets you select which switch record the form is showing. There are a few text boxes that store info on the switch (such as the number of ports).

Adding new switches seems to work fine. I have used the standard DoCmd.GoToRecord , , acNewRec and I update the info with some input boxes and some default data. All good.

My problem happens when I try to change the switch name. This is not the primpary key (have autonumber for that) I have tried changing the values on the current record, as well as trying using a recordset. The data does not seem to get updated until I hit the [Refresh All] button on the Ribbon. I did code a me.refresh, but this does not seem to cut it. Am I doing something wrong?

Please Login or Register  to view this content.

BTW, the debog.print Me.SwitchIP returns a blank, instead of the new value.

Got it to work, and I think it might have to do a bit with the combobox. What I ended up doing is first getting the listindex of the selected item (that is being renamed), then after making the change, requerying the combobox, forcing it back to the same index (just incase) and then running a refresh. This seems to do the trick.