Re: [AccessDevelopers] Form Not Updating until next record

[Toby Bierly]

I can't read the database you sent to the group (also, usually files are uploaded to the group website, not sure if we're supposed to send to the group or not).   But let me explain the below situation better.   The code I gave you should go in the Code Builder.  In Design mode on the form, right click on the ComboBox and click Properties.  On the Events tab, find the AfterUpdate event.  Click on the ellipses (...) on the right side of the AfterUpdate line, and choose Code Builder.  It should take you to the code window with the cursor inside the AfterUpdate event code.  This is where you should paste       Me.SubFormName.Form.RecordsetClone.FindFirst "[ContactID] = " & Me![ComboBoxName]     Me.SubFormName.Form.Bookmark = Me.SubFormName.Form.RecordsetClone.Bookmark   As stated before you will need to replace SubFormName and ComboBoxName with the correct names.  Also, ContactID should be whatever the name of the ID field is in your Contact table.   Hope that works for you.  Changing the selection in the ComboBox should now change the data in the subform holding the contact data.   HTH, 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 > > > > > > 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.