Pop-Up Form Question

[DKF]

Hello,

I have created a form for my HR department. Sometimes the user will be updating a current employee and sometimes they will be entering in a new employee.

I would like to create a pop-up form to ask the user if they are updating information or entering a new employee. Then based on the answer - either a blank form opens for a search or a blank form opens for a new employee entry.

I have tried making the data entry = Yes in the Properties of the form but that seems to only allow new employee entry - not a current employee search.

I don't know how to write Macros/Expressions/VBA code so details would be really appreciated. Thanks.

[Access_Blaster]

Hi DKF,


Just have a button off to the side with a label "Add New Employee" This would open your popup form. In the popup's ON Open Event: place this code.

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

Take a look at this, I have a popup to add "Job Skills"
https://www.accessforums.net/access/...html#post24073