Search results

solution found GJT, Thanks for your efforts. I found the solution elsewhere in this forum. The following code works: DoCmd.RunCommand acCmdSaveRecord The code I was using DoCmd.RunCommand acCmdSave was obviously saving the whole recordset (if that makes any sense). The code above saves...

stay on same record Thanks GJT, Yes, I have commented out that line but it doesn't change anything. Seasider

stay on same record Hello GJT, thanks again for responding. My problem is precicely that after I save, it goes to the first record in the record source. I want it to stay on the record I am saving. For example, if I am saving changes to record 6, then I want the form to stay opened at that...

not paging to next record sorry, I didn't answer your question directly. I am saving by clicking the save command button and not any other navigation buttons. Thanks

stay on same record Thanks for responding. I'm stumped on this one. I have a SAVE command button on the form with this code: Private Sub cmdSave_Click() On Error GoTo Err_cmdSave_Click 'DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.RunCommand acCmdSave...

In the BeforeUpdaate event on a form, I have a message box that prompts the user to confirm that they want to save the record. If vbYesNo = yes, the record saves properly but after the record is saved the form moves to the first record. How can this be coded so that the form stays on the...

Checkbox and required date I had a similar problem to yours. I had a checkbox on a form and a date field where I wanted to force the user to enter a date when the checkbox was checked. Conversely, I did not want the user to be able to enter a date if the checkbox was not checked. After many...

Re Required Entry of Date I had the exact same situation as you and I searched this forum for a solution but did not find one to suit my problem although I have found many other solutions here and am grateful for the help. In my case, I had a checkbox on a form that a user can check if Data...

Problem solved Thanks for your help Wayne. I used a modified version of your idea about using DCount and everything is working great now. Really appreciate your help as well as all that I have learned from reading other discussions in these forums. Seasider

Further explanation Thanks for responding Wayne. I have 3 separate queries to count the totals for each of the checkboxes - cntActive, cntNewsletter, cntAnnualRpt The SQL for these is similar. Here is the SQL for the cntActive one: Select count(contacts.ActiveStatus) as cntActive...

I'd really appreciate some help. I am just learning VBA on my own. I have a form with 3 checkboxes: ActiveStatus, Newsletter, and AnnualReport. I have placed code in the On Click event of the ActiveStatus control to prevent the user from CHECKING either the Newsletter or AnnualReport unless...

checkboxes on form Thanks Ally Yes, that works but it goes in the Afterupdate on the form, not the checkbox. It may also work the way you sugges but I had already found the answer. I am new to these forums and am still learning how to search for solutions. Thanks to you and everyone else for...

I am new to using VBA and also to using forums but have found this one to be extremely helpful. This is my first post. I have a form with (among other fields) four checkboxes. The form also contains a subform. The subform is used to count the checks from the checkboxes. When user checks the...