[AccessD] what is the right way to write this code

Hi Joe

Try:

If Not IsNull(Me.JobTitleID) Then 
   Me.cboJob_Title.Value = Me.cboJob_Title.Column(1)      
End If


-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
> Sent: 29 November 2004 19:10
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] what is the right way to write this code
> 
> 
>   
> 
>  
> 
>  If Me.JobTitleID Is Null Then                  'If row is 
> blank do nothing
> 
>         Else
> 
>        Me.cboJob_Title.Value = Me.cboJob_Title.Column(1)      
>       'Display
> job title
> 
>  
> 
>    End If
> 
>  
> 
> Rowsource =
> 
> SELECT [Job Title].JobTitleID, [Job Title].JobTitle
> 
> FROM [Job Title]
> 
> ORDER BY [Job Title].JobTitle;
> 
>     
> 
>  
> 
> JOE HECHT
> 
> LOS ANGELES CA 
> 
> jmhla at earthlink.net
> 
>  
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>