Charlotte Foust
charlotte.foust at gmail.com
Tue Apr 2 15:34:41 CDT 2013
Where is the code now? What event? Charlotte On Tue, Apr 2, 2013 at 7:49 AM, Kaup, Chester <Chester_Kaup at kindermorgan.com > wrote: > I have a data entry form. The first entry is a list box where the user > selects a company name. List box name is companyname. The next data entry > is an invoice number. I am trying to set the default value property of the > text box using the following statement. The default value is not becoming > part of the saved data. Thanks for the help > > =IIf([CompanyName].[Value]="Renegade","RWLS",Null) > > I also tried > =IIf([CompanyName]="Renegade","RWLS",Null) > > Do I maybe need to set it using code in the after update event of the list > box? > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >