Control Does Not Update When Append is used

[Kevsim]

I have a table called Fix and another called Documentation, with Primary Keys FixID and DocsID.
These 2 tables are connected to each other through a Junction table which has the Foreign keys FixID and DocsID.

There is a form called Fix, the form works well with all the Fix controls.
I have added a combo box on the Fix form called Documentation (to update the Junction table, FixID & DocsID).

When adding a totally new record (Append) to the Junction table, the table updates but the Junction table "Record No control"(Text286)on Form Fix does not.
I receive the message "You Are About To Append One Row".
I check for the update by moving one record up then one back on the Form Fix.
If I close the form and reopen all is OK.

I have tried –
Forms![F_Fix]!Text286.Requery
DoCmd.Requery "Text286"

When using Update from the combo box all works OK.

I hope you can understand this explanation, if not please request further detail.

I would appreciate your advise on how to fix this issue.
kevsim

 

[jedraw]

Try Application.RefreshDatabaseWindow

 

[Kevsim]

jedraw,
Thanks for the help,
Control still does not update.
kevsim

 

[jsteph]

Try Forms![F_Fix].Requery
--Jim

 

[Kevsim]

jsteph,
Thanks for the help, works well.
I had to bookmark the record as when I ran the code it always returned to record No1.
My final code is -

Dim currRecord As Integer
currRecord = Me.CurrentRecord
Forms![F_Fix].Requery
DoCmd.GoToRecord , , acGoTo, currRecord

kevsim