Re: [AccessDevelopers] Form Not Updating until next record

Wed, 07 Dec 2005 11:51:29 -0800

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 -----
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: <[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! 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



Reply via email to