refresh subform after adding records to related table

[altesse33]

I have a command button on the main form of my database that allows users to add new records. But, even though new records get added to the sub table when I click on the button, those new records aren’t immediately reflected in the combo box that is on the subform (whose record source is a junction table).

Do you know of any methods I can add in an event procedure to update the subform? I added the following code based on a suggestion I read on another post:

- Command button is called "AddAuthor"
- Command button adds new records (Authors) to "frmAuthors "
- Combo box that I want to refresh is found on subform "frmCiteAuthors "

Private Sub AddAuthor_Exit( Cancel As Integer)


DoCmd.Close acForm, "frmAuthors "
Dim varBookmark As Variant

varBookmark = Forms![frmCiteAuthors].Bookmark
Forms![frmCiteAuthors].Requery

Forms![frmCiteAuthors].Bookmark = varBookmark

I get an error message that Access can't find the form frmCiteAuthors. I tried taking the form name out of brackets so that it looked like this:

Forms!frmCiteAu thors.Bookmark = varBookmark

but that didn't change anything .

What am I doing wrong? What code should I be using?

Thanks for your help.

[Anca Floria]

I had the same problem so what I did was this:

in the subform I updated to Requery the OnFocus property of the control I wanted to be refreshed (so that instead of showing all records, it would show only the records related to the data entered in the main form):

Private Sub MeetingSubID_Go tFocus()
MeetingSubID.Re query
End Sub

So if in the main form I entered a new Meeting when I clicked the MeetingSubID textfield in the subform (in order to add details to the meeting, such as as many participants as I wish) it was automatically updated, as it was linked to the main form in Row Source through the query

SELECT Meetings.Meetin gSubID FROM Meetings WHERE (((Meetings.Mee tingSubID)=Form s![Add Meetings]!MeetingID));

* Meetings is the Subform/table
* Add Meetings is the Main Form/table
* Meetings.Meetin gSubID is the Child field
* Add Meetings!Meetin gID is the Master field

[rsmolik]

I have found a way to fix the Not find form. You need to reference the Main Form the sub form is coming of like this;

Forms("MainForm Name").[frmSubFrmName].Form.Requery

And you are laughing.

Regard

Richard