I think I see the problem. Sorry.
cboMemCat is on form Individuals.
txtAmountDue is on a subform called [Member Dues], which
is on form Individuals. So I tried to reference where
cboMemCat was coming from
=IIf(Len(((Individuals![cboMemCat].[Column](2))) & "") =0,
Null,(Individuals![cboMemCat].Column(2)))
but that didn't work either. So, txtAmountDue can't find
cboMemCat. Thanks.
-----Original Message-----
Then one of these things is the problem:
(1) You don't have a third column in the cboMemCat
combobox's Row Source
(Column is a zero-based property, so Column(2) is the
third field in the
RowSource query).
(2) Your combobox is not named cboMemCat.
(3) You have another control on the form that is also
named cboMemCat.
--
Ken Snell
<MS ACCESS MVP>
message
I moved the expression to the Control Source, but still
get the same result, "#Name?"
-----Original Message-----
Is the expression in the Default Value property or the
Control Source
property of txtAmountDue? It should be in the Control
Source property.
--
Ken Snell
<MS ACCESS MVP>
message
Ken, I went ahead and changed the name to
txtAmountDue,
but no joy. I still get "#Name?".
I think that may be the least of worries, as I'm not
sure
my form is sound, but one step at a time, right!
Thanks for the lessons.
-----Original Message-----
By chance, is this textbox still named AmountDue? If
yes,
then ACCESS may be
confused by the fact that you have a textbox named the
same as a field, but
they are not bound to each other. Change the name of
the
textbox to
txtAmountDue and see if that resolves your issue.
--
Ken Snell
<MS ACCESS MVP>
in
message
Thanks, Ken. I was able to have "currency" show in
my
[cboMemCat].[Column](2)field. Neat trick.
I am still unable to get the correct value populated
from
that currency field into my other field, AmountDue.
AmountDue is a field in my table. But on this form,
I've
erased the control source (so maybe I don't need to
store
this field in the table?) since I want it to be
populated
based on cboMemCat. I have the default value as
suggested:
=IIf(Len([cboMemCat].[Column](2) & "")=0,Null,
[cboMemCat].
[Column](2))
but still get "#Name?".
In the record source for the form itself, I do have
AmountDue as a table field, not a calculated field.
Could
that be it?
Thanks for the help!
-----Original Message-----
Comments inline...
--
Ken Snell
<MS ACCESS MVP>
"SillySally" <
[email protected]>
wrote
in
message
Fabulous Ken!
Thanks for the reply. I still can't get the
value I
want
so let me explain a bit more.
I have field cboMemCat which is combo box to
choose
the
Member's Category. I have an unbound field (I'm
guessing
that may be the problem) that is cboMemCat.Column
(2)
which
holds the Members's Dues. I called this field
MemDues.
This is the field that I want to be the source for
my
other field. I want MemDues field to be
currency.
The
field in the table is currency, I used the
properties
of
the field to select currency. It still shows up
as
a
number. Any suggestions?
Often, the query that is used for the Row Source of
a
combo box will change
the data type to text for the combo box's list.
Thus,
if
you want the
dropdown list to show a currency "view" (with $),
you
need to modify the
query to explicitly have the data be currency. In
place
of the real field
that is the third column (your Column(2)), use a
calculated field like this:
DollarAmt: CCur([FieldName])
or an calculated field like this:
DollarAmt: Format([FieldName], "$0.00")
OK then. I changed the control source of my other
field,
AmountDue, to =IIf(Len([MemDues] & "")=0,Null,
[MemDues])
cboMemCat.Column(2) shows 75 (although I'd like to
show
$75), but AmountDue shows "#Name?"
So, I also tried to have AnountDue as
=IIf(Len((cboMemCat.Column(2)) & "")=0,Null,
(cboMemCat.Column(2)))
but that also gave me AmountDue as "#Name?"
In order to use a specific column from a combo box's
Row
Source, you don't
use the name of the field that is in that Row
Source.
Instead, use the
Column(2) reference:
=IIf(Len([cboMemCat].[Column](2) & "")=0,Null,
[cboMemCat].
[Column](2))
Which I remember from before,probably means that
the
control source is incorrect. Any suggestions?
Thanks for your time!
-----Original Message-----
Default Value property would be this:
=IIf(Len([FieldOnTab1] & "")=0, Null,
[FieldOnTab1])
--
Ken Snell
<MS ACCESS MVP>
"SillySally" <
[email protected]>
wrote
in
message
Hi. I have a field on a tabbed form that I'd
like
to
reference on a field in another tab in that
form.
MyForm
MyFormTab1
FieldOnTab1
MyFormTab2
FieldOnTab2
I want FieldOnTab2 to default to FieldOnTab1, if
FieldOnTab1 is not null.
I tried many combinations that didn't work. Any
suggestions? Thanks!
.
.
.
.
.
