Recent content by logik

I have this working now. One of the problems was using Gotorecord using the automatically generated ID. This is not on my form and gave an error. Took a while to figure that out. TempVars also helped with the logic.

I'm sure you haven't missed the point ☺ Yes I have the ID but what to do with it? Are you thinking Gotorecord in onactivate?

My OnActivate is definitely called as I have a breakpoint in it. I have a dataset form, a button opens a single record form to edit or add a new one. This form is closed and, as I have to do a requery to ensure the new record is visible in the dataset form, I lose my original position. I am...

Thanks. The recordset is bookmarkable. I have applied the test above to check and used the varBookmark as you suggest. This starts empty but is not updated even though the line is executed. Bookmark seems to be a structure rather than a number.

Hello, I am using Findfirst to move the current focus to a record identified by an ID. The ID is my primary key, type autonumber. I have my record set, I know the ID but I am confused by the syntax of Findfirst and the subsequent use of bookmarks. I am calling this from the OnActivate event...

I had it after the save record but have now shifted the requery to after the Close Window command and that seems to work. I have plenty more still to work on but this was bugging me. Many thanks for the prompt and helpful replies

Yes, I can see the requery being called when I include it on the On Click of the "Add Button" but the first form is still not updated with the new record. A manual refresh shows it so I tried to add a refresh into the On Activate in the first form but to no avail.

That is the case. I have a datasheet form and a pop up, single record form. When the single record form is closed, I call requery on On Activate in the datasheet form to see the complete, updated record list. However, the On Activate also gets called on Load and if the user cancels the record...

Hello, I use requery in the On Activate event of a form to ensure all the records are visible after a new record has been added. However, I note that this event is called whether a record has been added or not which seems a waste of time. The Dirty boolean value in the form does not seem to...