Converting from Access 2003 to 2007 - Form won't open 1

[Penny001]

I converted a 2003 database to 2007 and all works well except for one form. This form opens to only a gray screen. This form is the only one that opens with a filter - I'm not sure if this is the problem.

PROPERTIES:
RECORD SOURCE = EMPLOYEEWITHTOOLS
FILTER: EMPL_ID = Forms!CheckInOutTools!InpEmpID

ON CURRENT:
Private Sub Form_Current()
Me.InpEmpID = Me.EMPL_ID
DoCmd.Maximize
End Sub

ON GOT FOCUS:
Private Sub Form_GotFocus()
Me.Requery
End Sub



UNBOUND FIELD: NAME = INPEMPID
ROW SOURCE: SELECT DISTINCT AllEmployeesAndTools.EMPL_ID FROM AllEmployeesAndTools;

AFTER UPDATE:
Private Sub InpEmpID_AfterUpdate()
txtUserUpdated = False
DoCmd.ApplyFilter , "EMPL_ID = Forms!CheckInOutTools!InpEmpID"
End Sub


Can anyone give me an idea why this form will not open in Access 2007? Any help is appreciated.

 

[Axworthy]

I would guess that no records meet the filter specified. When you open a bound form with zero records, you get a blank screen and see none of the controls.

 

[Penny001]

It works great in 2003...the form opens with zero records and you type in an empl nr (or choose from pulldown) in the UNBOUND FIELD: INPEMPID...

It's something in this form that 2007 does not like. I don't have a clue what it is?