Solved Linked form not filtering (1 Viewer)

Kayleigh

Member
Local time
Today, 10:23
Joined
Sep 24, 2020
Messages
706
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: 98

theDBguy

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

Kayleigh

Member
Local time
Today, 10:23
Joined
Sep 24, 2020
Messages
706
Perfect thanks!
 

Users who are viewing this thread

Top Bottom