Form records has only 1 but should have many

  • Thread starter Thread starter Alan T
  • Start date Start date
A

Alan T

I have a main form with a button when click will execute:
Private Sub btnCreateEmployee_Click()
DoCmd.OpenForm "frmEmployee", acNormal, , , acFormEdit, acWindowNormal
End Sub

Most of the time when the frmEmployee opens up will show only 1 record on
the record selector.
I need to return to the main form and click the button again to open up the
frmEmployee again to see there are many records on the record selector, any
idea?
 
Alan,

Try leaving out some of the arguments.

DoCmd.OpenForm "frmEmployee", acNormal

This should do the trick. Also make sure there is not a filter active (look
in properties of the form and the filterbutton in the access toolbar).
 
Back
Top