Re: [AccessDevelopers] Form Not Updating until next record

[Toby Bierly]

I only have Access 97.  I could take a glance if you can zip it and send it in that format.   Toby ----- Original Message ----- From: Joe Fonseca To: AccessDevelopers@yahoogroups.com Sent: Wednesday, December 07, 2005 11:51 AM Subject: Re: [AccessDevelopers] Form Not Updating until next record Can I send you my DB to see what I"m doing wrong? Toby Bierly <[EMAIL PROTECTED]> wrote: Code Builder for the AfterUpdate event   Toby ----- Original Message ----- From: Joe Fonseca To: AccessDevelopers@yahoogroups.com Sent: Wednesday, December 07, 2005 11:42 AM Subject: Re: [AccessDevelopers] Form Not Updating until next record Do i Put the text below in as an _expression_ Builder, Macro Builder, or Code Builder?  or do I just click the Event Procedure and then type it in there? Toby Bierly <[EMAIL PROTECTED]> wrote: In the AfterUpdate of the dropdown (ComboBox), put     Me.SubFormName.Form.RecordsetClone.FindFirst "[ID] = " & Me![ComboBoxName]     Me.SubFormName.Form.Bookmark = Me.SubFormName.Form.RecordsetClone.Bookmark replacing SubFormName ! and ComboBoxName with the appropriate names, of course. HTH, Toby ----- Original Message ----- From: "Joe" <[EMAIL PROTECTED]> To: <AccessDevelopers@yahoogroups.com> Sent: Wednesday, December 07, 2005 6:42 AM Subject: [AccessDevelopers] Form Not Updating until next record > I have got a! form that has a drop down to select a Contact name. > > Then under that name dropdown i have a subform that is in a tab sheet > that should update when the above Contact is selected. > > Under the contact info I have another piece of the main form that has > study information that is the main data piece. > > The problem is when I selecte the contact name from the drop down it > does not update until I go to the next record / (Study). > > Any suggestions? > > I took off the ability for naviagion buttons and record selection for > the contact subform.!   But I don't think that should have affected it. > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > Yahoo! DSL Something to write home about. Just $16.99/mo. or less Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.