Access 2007 Error 2499
Unanswered Topics Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA DoCmd.GoToRecord Error in Access VBA User Name Remember Me? Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Access VBA Discuss using VBA for Access programming. Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... Welcome to the p2p.wrox.com Forums. You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free . Thread Tools Display Modes #1 (permalink) October 29th, 2004, 09:36 PM myth12345 Authorized User Join Date: Oct 2004 Location: , , . Posts: 13 Thanks: 0 Thanked 0 Times in 0 Posts DoCmd.GoToRecord Error in Access VBA Actually, I had not pasted the complete code. I have a main form and subform in Access. In the main form I have some fields from the master table and in the subform I have the fields from detail table. Now when I select the Diet (which is in the main form)from the combo box in the master form and click on the OK button, the subform should fill with all the records corresponding to that diet in the subform. But when I run the application, only the last record is being displayed in the subform. That is if there are fifteen records correspnding to Diet A then all the fifteen records are not displayed. Instead, only the last record is displayed in 15 rows. When I run the program step by step by using F8 key, then I get the error Run-time error 2499: You cant use the GotoRecord action or method on an object in Design view. in the st
Design View! If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: Help! Getting Error 2499 Cant Use GoToRecord In Design View! Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread http://p2p.wrox.com/access-vba/20615-docmd-gotorecord-error-access-vba.html Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-29-07,06:01 #1 dabooj View Profile View Forum Posts Registered User Join Date Sep 2006 Posts 30 Unanswered: Help! Getting Error 2499 Cant Use GoToRecord In Design View! Hi Guys, RE: Access 2000 I assume that this error has cropped up in these forums a few times http://www.dbforums.com/showthread.php?1614451-Help!-Getting-Error-2499-Cant-Use-GoToRecord-In-Design-View! before but i can't seem to find it. I have a bit of code which checks the fields on a form using the beforeupdate method and validates the results. If contents are correct the file saves. if not the incorrect fields are highlighted in red. At the moment the incorrect entries are being highlighted but when i enter in a record without ant errors the navigation buttons don't respond (i.s previous & next buttons don't do anything and record remains on screen). I have an error handler which catches a few error types and ignores them but when i debug the code i get the error 'runtime error 2499: cant use the gotorecord method in design view'. What does that mean? i'm not using it in design view! it is just the wizard-created navigation buttons. Code is as follows: The beforeUpdate runs this code to validate fields in the form. The cmdNext button code is also show at the bottom: Code: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim intCancelUpdateCount As Integer Dim strReferralMsg As St
question and get tips & solutions from a community of 418,417 IT Pros & Developers. It's quick & easy. Run-time error '2499' P: n/a dee I have a form 'FmMessages" and a form 'FmLeads'. 'FmMessages', through code, opens 'FmMessages" if it is https://bytes.com/topic/access/answers/829709-run-time-error-2499-a not already open. It then sets focus on 'FmLeads' and runs the following code: Dim rst As Object Dim Tid As Long If typetransfer = "Valid Number" Or typetransfer = "New Number" Then DoCmd.GoToRecord , , acNewRec Me.ID = Forms![FmMessages].testCode Set rst = Me.Recordset.Clone Tid = Me.ID If Not IsNull(DLookup("ID", "Contacts", "ID = " & Tid)) Then MsgBox "ID Number Already Exists", vbExclamation, "Taking you to that record" Me.Undo rst.FindFirst "ID = " & Tid Me.Bookmark = rst.Bookmark End If ....more code access 2007 here End if All of this runs just fine if 'FmLeads' was closed and then opened by code in 'FmMessages'. My problem comes when the 'FmLeads' form is already open. The line: DoCmd.GoToRecord , , acNewRec now produces the following error: Run-time error '2499' "You can't use GoToRecord a"ction or method on an object in Design view" Needles to say, form 'FmLeads' is not open in design view, and it does have focus. Your help would be very much appreciated Aug 13 '08 access 2007 error #1 Post Reply Share this Question 1 Reply P: n/a Bruce On Aug 13, 3:48*pm, dee