How open form for new record but allow user to get an existing record with a combobox
Posted on 2014-03-12
Is this possible?
On a main menu form I have a command button that opens a 2nd form using:
DoCmd.OpenForm "frmImages", acNormal, , , acFormAdd, acWindowNormal
But on the 2nd form I have a combobox which is supposed to allow the user to find an existing record. But it doesn't work probably because I'm opening the form for new record.
Here is the code for the afterupdate event of the combobox:
Dim RS As Object
Set RS = Me.Recordset.Clone
RS.FindFirst "[ImageID] = " & Str(Nz(Me![cboFindRecord], 0))
If Not RS.EOF Then Me.Bookmark = RS.Bookmark
Is it even possible to have a form open for new but also go to an existing record?