I think we need a bit more detail, Joel. Normally one does not place the variable as well as the column, just the column.
--- Joel Solomon <[EMAIL PROTECTED]> wrote: > Albert, > > I created a variable vlocation. When I add the vlocation to my form, I > get the results in the variable. But when I try to use the variable as the > default for a field in the form, I get nothing. > > Why would the variable show on the form but the filed with the variable as a > default not show? > > Thanks > Joel > ----- Original Message ----- > From: "Albert Berry" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Wednesday, June 16, 2004 12:50 PM > Subject: [RBG7-L] - Re: Form Control Properties > > > > Joel, create a variable in the form that applies the default value unless > there > > is already a value there. > > > > ColumnValue = (IFNULL(ColumnValue,.Default,ColumnValue)) > > > > --- Joel Solomon <[EMAIL PROTECTED]> wrote: > > > Can you use the results of a variable as the default value for a field > in a > > > form? I have set up in my form a DB Edit field and under > > > properties/effects/default value used .vlocation (a variable I set up in > the > > > form). When I add data to the form, the default variable does not > appear. > > > Is there a special format I need to use or will this just not work. > > > > > > > > > Joel Solomon > > > Controller > > > Barbizon International > > > [EMAIL PROTECTED] > > > Ph: 954-345-4140 ext. 203 > > > Fax: 954-345-8055 > > > >
