Joe- If Me.List13
.. tests the current value of the list box, which if there is nothing selected, will be Null. Use what I gave you: If Me.List13.ListCount = 0 Then .. checks the value in the ListCount property of the list box control, and ListCount contains the number of rows. If the requery returned zero rows, the ListCount will be zero. One catch: If you have turned on Column Headings, the ListCount will always be at least 1 (the header row). So, if Column Headings is Yes, test for the value 1. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of eliotchs Sent: Friday, January 06, 2006 10:39 AM To: [email protected] Subject: [ms_access] Re: ?? on Requery is null..put up message ?? Hi John, Thanks for the quick response... I tried the following Private Sub Combo34_Change() DoCmd.Requery "LIST13" Me.List13.Requery If Me.List13 = 0 Then MsgBox "test" End If End Sub I also tried IF me.List13 is Null Then DO I need it in a different location or is the value actually not null on the requery? Thanks Joe --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Joe- > > If Me.lstBox.ListCount = 0 Then > ... > > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of eliotchs > Sent: Friday, January 06, 2006 10:09 AM > To: [email protected] > Subject: [ms_access] ?? on Requery is null..put up message ?? > > Hi, > > I should know this.. but I'm getting hung up on it. > I have a Listbox which does a requery when a location is chaged on a > combobox. > What I'd like is to make a label or msgbox visible if the requery is > null when changing the location. > > Thanks in advance > > Joe > > > > > > > > Yahoo! Groups Links > Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> 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/
