Form records has only 1 but should have many

[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?

 

[Guest]

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).