Thanks John, Sorry , got confused with ListCount, Somehow thought it was supposed to be my field name..
Thanks Again, Have a great weekend!! Joe --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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/
