If null then update

's Computer Specifications

I'm ha ving problems updating a field .

I have a macro that takes data from one form and puts it into another
form but only if the destination field if blank - otherwise the
destination field isnt' to be updated

my setvalue expressions are as follows:

item: Forms![AWB Main Info]![Handling Information]
Expression: Nz([Handling Information],Forms![Flight Details]![leg3])

[Handling Information] = the destination field
and if that field is empty then i would like the info from [Flight
Details]![leg3] to be inserted
if that field has data in it already then i don't want the [leg3] data
entered into it.

Can someone please help me with this expression?

thanks
Steve

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Append/Update Query: If fieldname is null then update	=?Utf-8?B?UkRSZXNlYXJjaA==?=	Microsoft Access Queries	1	23rd Mar 2007 05:17 AM
If number >8, subtract 8 /if txtlot is null then this is null too	=?Utf-8?B?V2FsdGVyIE1pbGxz?=	Microsoft Access	4	16th Jan 2006 10:05 PM
if greater then 99 then 1 if greater then 199 then two	=?Utf-8?B?Ti5SLg==?=	Microsoft Excel Worksheet Functions	2	23rd Jun 2005 06:14 PM
Need help with a log off/log on problem...can log off then log on dif. user and system will be slow loading user settings, then play start up music, then show wallpaper, then freeze.	Ralph Malph	Windows XP General	2	9th Feb 2005 07:05 AM
Null result when combining null field with non-null field in ADP View	Lauren Quantrell	Microsoft Access Form Coding	8	17th Nov 2003 03:34 AM