Re: [AccessDevelopers] Form Not Updating until next record

Wed, 07 Dec 2005 10:49:52 -0800

You are the man!!! Thanks!

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! Personals
Single? There's someone we'd like you to meet.
Lots of someones, actually. Yahoo! Personals


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



Reply via email to