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! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
