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 <*> 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/
