Search results

On opening access form frmPersonnel, 2 blank records are added to the underlying table tblPerson. It only happens when the form is initially opened. Below is the coding for this form for Open, Load and Current events Private Sub Form_Open(Cancel As Integer) If glbHandleErrors Then On Error...

Many thanks for all your comments. In the end went down a slightly different pathway instead of using BookMarking I used Docmd.applyfilter instead to return to the previous record. However I still kept on getting error 2501 on the DoCmd.ApplyFilter, that is till I restructured the code as...

Gasman New to posting on forums. What the chuffing hell are code tags?

Sorry as they say in the circus good try but no coconut! I have amended the code as you suggested now getting the message "error 3426 - this action is cancelled by associated object"

1. I have a form frmPersonnel which logs persons name address etc. 2. On that form I have a new record button which brings up new record based upon click event below: DIM strBookMark as variant - Set at top of form module frmPersonnel so available to all sub procedures in module. Private Sub...

Been using Access on and off for the last 30 years. I'm old enough to have worked with its predecessor Ashton Tates dBase!! Now in my dotage as a retiree, keeping the old grey matter active by developing an Access database system for a charity called Walton Lea Partnership that provide...