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:
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: <[email protected]>
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 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.
Yahoo! Personals
Let fate take it's course directly to your email.
See who's waiting for you Yahoo! Personals
Please zip all files prior to uploading to Files section.
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.
