How to add record, but keep the same record in Forms View 1

[hawkeye71]

I am using Acces 2000 on Windows 2000.
In the FORM view, I want to click a button, the click of button should do the following:
1. Add the record in the table
2. Move to the next record
3. In the list of drop down combo boxes, make all the previous records available.

At present,
1. it adds the record,
2. move to the next record,

but does not show me the previous entries in the drop down combo boxes unless I exit out of the form and start the form again.

Here is what I coded for the OnClick property of the cmd button:
Private Sub button_add_record_Click()
On Error GoTo Err_button_add_record_Click

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.GoToRecord , , acNewRec
DoCmd.GoToControl ("Site_Name")

All the help is appreciated.

Thanks,
Indiana

 

[TheAceMan1]

How are ya hawkeye71 . . . . .

You need to [blue]Requery[/blue] the Combobox.

Me![purple]ComboboxName[/purple].Requery

See Ya! . . . . . .