Solved Linked form not filtering (1 Viewer)

Krayna

Member
Local time
Today, 04:17
Joined
Sep 24, 2020
Messages
326
Hi there,
I am working on a database which records staff training so I have a continuous form listing all training and these should double-click to open the training in detail but it is currently not displaying anything in the form when opened on filter - not sure why?
(This is part of a larger database but haven't included tblStaff due to confidentiality.)

Also can you advise how I can do a vba delete command on the frmTrainingCo?
And also considering if it would work better to have frmTrainingList to be based on a query rather than table to avoid using combo boxes?

Appreciate all advice here....
Krayna
 

Attachments

  • TrainingTest.accdb
    756 KB · Views: 34

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 20:17
Joined
Oct 29, 2018
Messages
15,227
Hi. It's because you have the following in your Form's Load event.
Code:
Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub
 

Krayna

Member
Local time
Today, 04:17
Joined
Sep 24, 2020
Messages
326
Perfect thanks!
 

Users who are viewing this thread

Top Bottom