Form and subform filtered by list box and combo box vs 2002

[Kay]

Hello,

I have a form and subform accessed from a non-access driven switchboard.
The form is for data entry and search. Included on the main form is a combo
that filters the main form by project owner and a list box that filters by
the project name. The problem is that when opening the form, a record shows
in the mainform and of course corresponding records in the subform and the
end-user will forget to choose from the drop-down for their records and then
change the exisitng record..not their own. Can you open the form and subform
so they are blank? Then when you choose from the list and combo box the
appropriate records appear.

Hope you can hope?

 

[Allen Browne]

To load a form with all records yet take it to the new record, try something
like this in the Event Procedure of the form's Load event:

Private Sub Form_Load()
If Not Me.NewRecord Then
RunCommand acCmdRecordsGotoNew
End If
End Sub

 

[Kay]

Thnks so much Allen, this appears to have worked.

Kay