Yes, my password is: Forgot your password? Expand|Select|Wrap|Line Numbers PrivateSubcmdDetails_Click() dimrsasdao.recordset setrs=me.recordsetclone rs.findfirst"[PromoCode]="&Me.PromoCode ifrs.nomatch=falsethen me.bookmark=rs.bookmark else msgbox"notfound" endif rs.close setrs=nothing endsub Nov 9 '06 #2 reply P: 5 mailing Thanks, I will try it. When the user pressed the new call button the line DoCmd.GoToRecord , , acNewRec took a new record. When the user clicks on the leftmost field, the second form opens at the correct record ready for action. find this

What is the proper syntax to accomplish this? Each event has a purpose and once you understand what the intent of the event is, it will be easier to place your code where it will work without adverse effects In the case of a new record, it has not yet been created. IMO, if the author doesn't want to accept any Expert comments, they should delete the question.

Join & Ask a Question Advertise Here Enjoyed your answer? Why would you want to use the undo command, instead of dirty? - will this stop it moving forward a record? It's a bit late for me now but using that is a very good way to start learning about VBA in Access and especially the common library routines. (D*mn - I I understand that the original recommendation arose out of an error caused by using DoCmd.RunCommand acCmdSaveRecord but I have experienced exactly the same issue it was intended to overcome in databases

I don't have Access 2.0, 85 or 97 available at this time so I cant test those. 0 LVL 35 Overall: Level 35 Microsoft Access 35 VBA 11 Microsoft Office Again, what you are asking for is not commonly done, ...so you need to re-evaluate the way you have designed your system. Dave E Dave Eyley View Public Profile Find More Posts by Dave Eyley

So there is no need to test if the form is dirty first like with your suggestion. 0 LVL 84 Overall: Level 84 Microsoft Access 83 Microsoft Office 14 VBA http://stackoverflow.com/questions/29717523/access-vba-open-form-on-current-record I really just meant that is has been so long since I'd used macros that I had forgotton the macro to code feature existed. The best advice I can give you is drop your preconceptions of how Access "should" work and learn how it "does" work and you will have less of a struggle with That is what leads to creating empty records.

Below is the code for Open the form I have so far. this content Nov 15 '06 #11 reply Expert Mod 10K+ P: 14,534 MMcCarthy Don't get me wrong Mary - I'm 100% with you on that. You may have accidentally typed spaces in one of your form properties. I agree, we are done. 0 Message Author Comment by:ssmith94015 ID: 409177722015-08-06 Pat, thank you for the information.

If there are only spaces in one of the properties (such as AfterUpdate or OnActivate), this message may go away if you delete the spaces. All rights reserved. Database Full Backup Maintenance Task has large delay between databases How to disclose negative information about a candidate when I'd rather not reveal its source? weblink There have been five other developers on this application before I got it and it is sloppy to pure laziness, not bothering to understand what was created, only adding another layer

I have attached a block of code that you should save in a separate code module… You may want to modify the code in the primary block to suit your Log in or Sign up Tech Support Guy Home Forums > Software & Hardware > Business Applications > Computer problem? example: Dim bolOtherCountryFlag as boolean' Set the country flag bolOtherCountryFlag = False ' set to false is the same country - true is other countryMe.TxtBoxOther1.visible

Department of Agriculture and Acronis Access Promoted by Acronis With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of

I have come across inherited applications with thousands of lines of code which I managed to condense into a few. Privacy Policy Support Terms of Use MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups Careers Store Your original attempt was not the same as what I posted. That is what "acFormAdd" says to do.

I have successfully accomplished this operation in another Prospecting database I have written. I am with Pat. Microsoft Access VBA Tax Refund Phishing Scam – Protect Your Money Article by: Dermot As tax season makes its return, so does the increase in cyber crime and tax refund phishing check over here There are very few other situations where you have to force Access to save rather than waiting for it to save automatically.

I would need to know more about the entire process to fine tune a solution. Is this wrong? Join over 733,556 other people just like you! If I was to go the Tabbed Form route the first problem I have is getting the current forms onto it.

The record source of frmMain is tblcustomer. Just verified with Access 2000, 2002, 2003, 2007, 2010, and 2013 and it works just fine. Then Simply add all records normally. If you ask people who have never before encountered the expression, they think that the save is being cancelled rather than being forced.

Thread Status: Not open for further replies. The advantage is since it effectively uses the command line to start a copy of Access and load your app, you can add command line options to the command line and There may very well be no "easy" answer for a question like this... It is like saving a record by using Me.Requery or Me.Refresh (which as we all know, cause unexpected side-effects for the unwary).

Any code I need that populates fields runs in the form's BeforeInsert event. Me.Dirty = False is the same as DoCmd.RunCommand acCmdSaveRecord 0 LVL 35 Overall: Level 35 Microsoft Access 35 VBA 11 Microsoft Office 7 Message Active today Expert Comment by:PatHartman As I suggested earlier: objAccess.DoCmd.OpenForm "YourFormName" should open that form, asssuming all went as planned when you grabbed the handle to that database. 0 Message Active today Author Comment by:ARampton Why isn't that simply a status of the calls table?