[AccessD] Requery on setting row source or record source

XP has help????????   I thought the HELP in XP was just there to tease?


> From: Lambert.Heenan at aig.com
> To: accessd at databaseadvisors.com
> Date: Wed, 12 Dec 2007 16:11:23 -0600
> Subject: Re: [AccessD] Requery on setting row source or record source
>
> Quite so. But I'm damned if I could find that in the XP help. Access 97 help
> was much more helpful! :-)
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
> Sent: Wednesday, December 12, 2007 4:25 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Requery on setting row source or record source
>
>
> acDataErrAdded Doesn't display a message to the user but enables you to add
> the entry to the combo box list in the NotInList event procedure. After the
> entry is added, Microsoft Access updates the list by requerying the combo
> box.
>
> Microsoft Access then rechecks the string against the combo box list, and
> saves the value in the NewData argument in the field the combo box is bound
> to. If the string is not in the list, then Microsoft Access displays an
> error message.
>
> Private Sub Colors_NotInList(NewData As String, _
> Response As Integer)
> Dim ctl As Control
>
> ' Return Control object that points to combo box.
> Set ctl = Me!Colors
> ' Prompt user to verify they wish to add new value.
> If MsgBox("Value is not in list. Add it?", _
> vbOKCancel) = vbOK Then
> ' Set Response argument to indicate that data
> ' is being added.
> Response = acDataErrAdded
> ' Add string in NewData argument to row source.
> ctl.RowSource = ctl.RowSource & ";" & NewData
> Else
> ' If user chooses Cancel, suppress error message
> ' and undo changes.
> Response = acDataErrContinue
> ctl.Undo
> End If
> End Sub
>
>
> Regards
> Max
> (From the help page 'NOTINLIST')
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: Wednesday, December 12, 2007 9:02 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Requery on setting row source or record source
>
> Just remember, if you are using a NotInList routine to add items to the
> Combobox rowsource, you will need to requery.
>
> Charlotte
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
> Beach Access Software
> Sent: Wednesday, December 12, 2007 11:39 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Requery on setting row source or record source
>
> Thanks Charlotte. Commenting out all them extraneous requeries now.
>
> Rocky
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: Wednesday, December 12, 2007 10:42 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Requery on setting row source or record source
>
> If you set the source through code, you shouldn't need to requery. You need
> to requery when the values in the current list change.
>
> Charlotte Foust
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
i’m is proud to present Cause Effect, a series about real people making a difference.
http://im.live.com/Messenger/IM/MTV/?source=text_Cause_Effect