New User - Field population based on combo box selection

It still did not work.

"Gina Whipp" wrote:

Amy,

Yes that is the problem... Okay fixing DLookUp...

=IIf(Not IsNull([Combo18]),DLookUp("[Membership Fees]","[Membership Types
and Fees]","[MembershipID]=" & Me![Membership Type]),"")

Watch out for Word Wrap....

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, here is the DLookup from the text box:
=DLookUp("[Membership Fees]","[Membership Types and
Fees]","[MembershipID]="
& Me![Membership Type])

Yes, the combo box is showing as "Unbound" and the name of it is Combo18.

(fingers crossed) Is this the problem?


"Gina Whipp" wrote:

Amy,

The typical reasons for seeing #NAME? is Access is confused, either by a
mispelled name and Missing Reference and/or missing Control Source (see
below). So now the question is is your combo box unbound? I think you
should copy/paste here the DLookUp that you placed in the text box so I
can
see it. Perhaps, something is wrong there???


Typical reasons for #NAME?
Make sure that the field specified in the control's ControlSource
property
hasn't been removed from the underlying table or record source.

1. Check the spelling of the field name in the control's ControlSource
property.

2. If you specified an expression in the control's ControlSource
property,
make sure that there is an equal sign preceding the expression.

3. Check for missing references...


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, I went there, but I don't understand what this has to do with the
textbox giving me the error "#Name?". I am new at this so please break
it
down for me. I will go over what I have done so far with you again:

I have two tables established. One holds the contact info for the
members
and the other is just for the membership types and fees..

Table: Members
Fields: MemberID - numeric primary key (autonumber), Organization Name,
Street Address, Phone, etc. etc.

Table: Membership Types and Fees
Fields: MembershipID - numeric primary key (autonumber), Membership
Type,
Membership Fees (three fields only)

These two tables are not linked in any way. I want to create a form to
have
the information come together. Specifically, my problem is that I want
the
form to have a combo box to choose "Membership Type" and then have the
"Membership Fees" automatically inserted into the text box next to it
in
currency format. I want this selection to be specific to each record in
the
form and I also would eventually like to have this information
available
to
do a Mail Merge in Microsoft Word.



"Gina Whipp" wrote:

Amy,

No I don't mean References... my fault, please press the Code button
and
go
to Tools... References in the Module code window behind a form or
report.
Doesn't matter which one they are the same no matter which one you
select.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
I have already checked the names of the fields and tables and all is
as
it
should be. When you say References, do you mean Relationships?
References
is
not an option under Tools while I am in design of my form. When I go
to
relationships, there is nothing there.

Is there another way to do this?

"Gina Whipp" wrote:

Amy,

Perhaps check references... go to design of any form or report and
under
Tools... References... and resolve any that are MISSING. If none
are
missing, check to confirm the names of all fiedls and tables in the
DLookUp
function.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, I looked and I actually had it named "Fees".

Is there any other reason why this doesn't work?


"Gina Whipp" wrote:

Amy,

When you get a chance to look at it, you can't name the text box
any
name
that is included in the function. Please name it
txtMembershipFees.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
I named the text box Membership Fees, I think. I am at home now
so
I
can't
rember exactly. What should I look for when I get back?

"Gina Whipp" wrote:

What sis you name the text box?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
Hi Gina, it did not work I get "#Name?" in the box instead
of
the
price.

"Gina Whipp" wrote:

Amy,

Yes, it should go in the Control Source, could be I forgot
to
type
that.
And the DLookUp I provided should work, post back if it
doesn't!

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
Hi Gina, thank you for your response.

Yes, I do have the spaces in there. I did not realize
that
it
can
cause
issues, but thanks for letting me know.

Membership Types and Fees is the table
MembershipID is a numeric field and is also the primary
key
Membership Type is the second column in this table
Membership Fees is the third, not Currency. I just had
the
format
for
that
field set to Currency so that it would display dollars
instead
of
plain
numbers.

Where would I put the DLookUp statement? I am assuming
in
the
Control
Source
field in the properties of the text box I created called
"Membership
Fee",
but I am not positive.

"Gina Whipp" wrote:

Amy,

Just to be sure you typed in the Membership Types and
Fees
with
those
spaces
in it? Also you missed a few fields...

Table: Membership Types and Fees
MembershipID - Is this a numeric field?
Membership Type
Membership Currency - Or does it have another name?

Your combo box needs to be two columns MembershipID and
Membership
Type,
The first column can be hidden to all you see is
Membership
Type.
Potentially, you could use the below in an unbound text
box
as
long
as
the

Ay,

Does #NAME? disappear when you make a slection from the Combo18?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
It still did not work.

"Gina Whipp" wrote:

Amy,

Yes that is the problem... Okay fixing DLookUp...

=IIf(Not IsNull([Combo18]),DLookUp("[Membership Fees]","[Membership Types
and Fees]","[MembershipID]=" & Me![Membership Type]),"")

Watch out for Word Wrap....

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, here is the DLookup from the text box:
=DLookUp("[Membership Fees]","[Membership Types and
Fees]","[MembershipID]="
& Me![Membership Type])

Yes, the combo box is showing as "Unbound" and the name of it is
Combo18.

(fingers crossed) Is this the problem?


"Gina Whipp" wrote:

Amy,

The typical reasons for seeing #NAME? is Access is confused, either by
a
mispelled name and Missing Reference and/or missing Control Source
(see
below). So now the question is is your combo box unbound? I think
you
should copy/paste here the DLookUp that you placed in the text box so
I
can
see it. Perhaps, something is wrong there???


Typical reasons for #NAME?
Make sure that the field specified in the control's ControlSource
property
hasn't been removed from the underlying table or record source.

1. Check the spelling of the field name in the control's ControlSource
property.

2. If you specified an expression in the control's ControlSource
property,
make sure that there is an equal sign preceding the expression.

3. Check for missing references...


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, I went there, but I don't understand what this has to do with
the
textbox giving me the error "#Name?". I am new at this so please
break
it
down for me. I will go over what I have done so far with you again:

I have two tables established. One holds the contact info for the
members
and the other is just for the membership types and fees..

Table: Members
Fields: MemberID - numeric primary key (autonumber), Organization
Name,
Street Address, Phone, etc. etc.

Table: Membership Types and Fees
Fields: MembershipID - numeric primary key (autonumber), Membership
Type,
Membership Fees (three fields only)

These two tables are not linked in any way. I want to create a form
to
have
the information come together. Specifically, my problem is that I
want
the
form to have a combo box to choose "Membership Type" and then have
the
"Membership Fees" automatically inserted into the text box next to
it
in
currency format. I want this selection to be specific to each record
in
the
form and I also would eventually like to have this information
available
to
do a Mail Merge in Microsoft Word.



"Gina Whipp" wrote:

Amy,

No I don't mean References... my fault, please press the Code
button
and
go
to Tools... References in the Module code window behind a form or
report.
Doesn't matter which one they are the same no matter which one you
select.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
I have already checked the names of the fields and tables and all
is
as
it
should be. When you say References, do you mean Relationships?
References
is
not an option under Tools while I am in design of my form. When I
go
to
relationships, there is nothing there.

Is there another way to do this?

"Gina Whipp" wrote:

Amy,

Perhaps check references... go to design of any form or report
and
under
Tools... References... and resolve any that are MISSING. If
none
are
missing, check to confirm the names of all fiedls and tables in
the
DLookUp
function.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, I looked and I actually had it named "Fees".

Is there any other reason why this doesn't work?


"Gina Whipp" wrote:

Amy,

When you get a chance to look at it, you can't name the text
box
any
name
that is included in the function. Please name it
txtMembershipFees.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
I named the text box Membership Fees, I think. I am at home
now
so
I
can't
rember exactly. What should I look for when I get back?

"Gina Whipp" wrote:

What sis you name the text box?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
Hi Gina, it did not work I get "#Name?" in the box
instead
of
the
price.

"Gina Whipp" wrote:

Amy,

Yes, it should go in the Control Source, could be I
forgot
to
type
that.
And the DLookUp I provided should work, post back if it
doesn't!

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
Hi Gina, thank you for your response.

Yes, I do have the spaces in there. I did not realize
that
it
can
cause
issues, but thanks for letting me know.

Membership Types and Fees is the table
MembershipID is a numeric field and is also the
primary
key
Membership Type is the second column in this table
Membership Fees is the third, not Currency. I just
had
the
format
for
that
field set to Currency so that it would display
dollars
instead
of
plain
numbers.

Where would I put the DLookUp statement? I am
assuming
in
the
Control
Source
field in the properties of the text box I created
called
"Membership
Fee",
but I am not positive.

"Gina Whipp" wrote:

Amy,

Just to be sure you typed in the Membership Types
and
Fees
with
those
spaces
in it? Also you missed a few fields...

Table: Membership Types and Fees
MembershipID - Is this a numeric field?
Membership Type
Membership Currency - Or does it have another name?

Your combo box needs to be two columns MembershipID
and
Membership
Type,
The first column can be hidden to all you see is
Membership
Type.
Potentially, you could use the below in an unbound
text
box
as
long
as
the

Yes, it does. And it actually is appearing even when I don't make a selection
- it just shows up when I switch from design mode.

"Gina Whipp" wrote:

Ay,

Does #NAME? disappear when you make a slection from the Combo18?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
It still did not work.

"Gina Whipp" wrote:

Amy,

Yes that is the problem... Okay fixing DLookUp...

=IIf(Not IsNull([Combo18]),DLookUp("[Membership Fees]","[Membership Types
and Fees]","[MembershipID]=" & Me![Membership Type]),"")

Watch out for Word Wrap....

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, here is the DLookup from the text box:
=DLookUp("[Membership Fees]","[Membership Types and
Fees]","[MembershipID]="
& Me![Membership Type])

Yes, the combo box is showing as "Unbound" and the name of it is
Combo18.

(fingers crossed) Is this the problem?


"Gina Whipp" wrote:

Amy,

The typical reasons for seeing #NAME? is Access is confused, either by
a
mispelled name and Missing Reference and/or missing Control Source
(see
below). So now the question is is your combo box unbound? I think
you
should copy/paste here the DLookUp that you placed in the text box so
I
can
see it. Perhaps, something is wrong there???


Typical reasons for #NAME?
Make sure that the field specified in the control's ControlSource
property
hasn't been removed from the underlying table or record source.

1. Check the spelling of the field name in the control's ControlSource
property.

2. If you specified an expression in the control's ControlSource
property,
make sure that there is an equal sign preceding the expression.

3. Check for missing references...


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, I went there, but I don't understand what this has to do with
the
textbox giving me the error "#Name?". I am new at this so please
break
it
down for me. I will go over what I have done so far with you again:

I have two tables established. One holds the contact info for the
members
and the other is just for the membership types and fees..

Table: Members
Fields: MemberID - numeric primary key (autonumber), Organization
Name,
Street Address, Phone, etc. etc.

Table: Membership Types and Fees
Fields: MembershipID - numeric primary key (autonumber), Membership
Type,
Membership Fees (three fields only)

These two tables are not linked in any way. I want to create a form
to
have
the information come together. Specifically, my problem is that I
want
the
form to have a combo box to choose "Membership Type" and then have
the
"Membership Fees" automatically inserted into the text box next to
it
in
currency format. I want this selection to be specific to each record
in
the
form and I also would eventually like to have this information
available
to
do a Mail Merge in Microsoft Word.



"Gina Whipp" wrote:

Amy,

No I don't mean References... my fault, please press the Code
button
and
go
to Tools... References in the Module code window behind a form or
report.
Doesn't matter which one they are the same no matter which one you
select.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
I have already checked the names of the fields and tables and all
is
as
it
should be. When you say References, do you mean Relationships?
References
is
not an option under Tools while I am in design of my form. When I
go
to
relationships, there is nothing there.

Is there another way to do this?

"Gina Whipp" wrote:

Amy,

Perhaps check references... go to design of any form or report
and
under
Tools... References... and resolve any that are MISSING. If
none
are
missing, check to confirm the names of all fiedls and tables in
the
DLookUp
function.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, I looked and I actually had it named "Fees".

Is there any other reason why this doesn't work?


"Gina Whipp" wrote:

Amy,

When you get a chance to look at it, you can't name the text
box
any
name
that is included in the function. Please name it
txtMembershipFees.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
I named the text box Membership Fees, I think. I am at home
now
so
I
can't
rember exactly. What should I look for when I get back?

"Gina Whipp" wrote:

What sis you name the text box?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
Hi Gina, it did not work I get "#Name?" in the box
instead
of
the
price.

"Gina Whipp" wrote:

Amy,

Yes, it should go in the Control Source, could be I
forgot
to
type
that.
And the DLookUp I provided should work, post back if it
doesn't!

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
Hi Gina, thank you for your response.

Yes, I do have the spaces in there. I did not realize
that
it
can
cause
issues, but thanks for letting me know.

Membership Types and Fees is the table
MembershipID is a numeric field and is also the
primary
key
Membership Type is the second column in this table
Membership Fees is the third, not Currency. I just
had
the
format

Oops! I am sorry I read your reply wrong! It DOES NOT disappear when I make a
selection.

"Gina Whipp" wrote:

Ay,

Does #NAME? disappear when you make a slection from the Combo18?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
It still did not work.

"Gina Whipp" wrote:

Amy,

Yes that is the problem... Okay fixing DLookUp...

=IIf(Not IsNull([Combo18]),DLookUp("[Membership Fees]","[Membership Types
and Fees]","[MembershipID]=" & Me![Membership Type]),"")

Watch out for Word Wrap....

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, here is the DLookup from the text box:
=DLookUp("[Membership Fees]","[Membership Types and
Fees]","[MembershipID]="
& Me![Membership Type])

Yes, the combo box is showing as "Unbound" and the name of it is
Combo18.

(fingers crossed) Is this the problem?


"Gina Whipp" wrote:

Amy,

The typical reasons for seeing #NAME? is Access is confused, either by
a
mispelled name and Missing Reference and/or missing Control Source
(see
below). So now the question is is your combo box unbound? I think
you
should copy/paste here the DLookUp that you placed in the text box so
I
can
see it. Perhaps, something is wrong there???


Typical reasons for #NAME?
Make sure that the field specified in the control's ControlSource
property
hasn't been removed from the underlying table or record source.

1. Check the spelling of the field name in the control's ControlSource
property.

2. If you specified an expression in the control's ControlSource
property,
make sure that there is an equal sign preceding the expression.

3. Check for missing references...


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, I went there, but I don't understand what this has to do with
the
textbox giving me the error "#Name?". I am new at this so please
break
it
down for me. I will go over what I have done so far with you again:

I have two tables established. One holds the contact info for the
members
and the other is just for the membership types and fees..

Table: Members
Fields: MemberID - numeric primary key (autonumber), Organization
Name,
Street Address, Phone, etc. etc.

Table: Membership Types and Fees
Fields: MembershipID - numeric primary key (autonumber), Membership
Type,
Membership Fees (three fields only)

These two tables are not linked in any way. I want to create a form
to
have
the information come together. Specifically, my problem is that I
want
the
form to have a combo box to choose "Membership Type" and then have
the
"Membership Fees" automatically inserted into the text box next to
it
in
currency format. I want this selection to be specific to each record
in
the
form and I also would eventually like to have this information
available
to
do a Mail Merge in Microsoft Word.



"Gina Whipp" wrote:

Amy,

No I don't mean References... my fault, please press the Code
button
and
go
to Tools... References in the Module code window behind a form or
report.
Doesn't matter which one they are the same no matter which one you
select.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
I have already checked the names of the fields and tables and all
is
as
it
should be. When you say References, do you mean Relationships?
References
is
not an option under Tools while I am in design of my form. When I
go
to
relationships, there is nothing there.

Is there another way to do this?

"Gina Whipp" wrote:

Amy,

Perhaps check references... go to design of any form or report
and
under
Tools... References... and resolve any that are MISSING. If
none
are
missing, check to confirm the names of all fiedls and tables in
the
DLookUp
function.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, I looked and I actually had it named "Fees".

Is there any other reason why this doesn't work?


"Gina Whipp" wrote:

Amy,

When you get a chance to look at it, you can't name the text
box
any
name
that is included in the function. Please name it
txtMembershipFees.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
I named the text box Membership Fees, I think. I am at home
now
so
I
can't
rember exactly. What should I look for when I get back?

"Gina Whipp" wrote:

What sis you name the text box?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
Hi Gina, it did not work I get "#Name?" in the box
instead
of
the
price.

"Gina Whipp" wrote:

Amy,

Yes, it should go in the Control Source, could be I
forgot
to
type
that.
And the DLookUp I provided should work, post back if it
doesn't!

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
Hi Gina, thank you for your response.

Yes, I do have the spaces in there. I did not realize
that
it
can
cause
issues, but thanks for letting me know.

Membership Types and Fees is the table
MembershipID is a numeric field and is also the
primary
key
Membership Type is the second column in this table
Membership Fees is the third, not Currency. I just
had
the
format

Amy,

Then I must say it HAS to be one of the field names is either spelled
incorrectly or the data type has changed. So please go back and look at
each table and give me the exact name as it appears in the table, along with
the exact table name as it appears in the database container.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
news
Oops! I am sorry I read your reply wrong! It DOES NOT disappear when I
make a
selection.

"Gina Whipp" wrote:

Ay,

Does #NAME? disappear when you make a slection from the Combo18?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
It still did not work.

"Gina Whipp" wrote:

Amy,

Yes that is the problem... Okay fixing DLookUp...

=IIf(Not IsNull([Combo18]),DLookUp("[Membership Fees]","[Membership
Types
and Fees]","[MembershipID]=" & Me![Membership Type]),"")

Watch out for Word Wrap....

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, here is the DLookup from the text box:
=DLookUp("[Membership Fees]","[Membership Types and
Fees]","[MembershipID]="
& Me![Membership Type])

Yes, the combo box is showing as "Unbound" and the name of it is
Combo18.

(fingers crossed) Is this the problem?


"Gina Whipp" wrote:

Amy,

The typical reasons for seeing #NAME? is Access is confused, either
by
a
mispelled name and Missing Reference and/or missing Control Source
(see
below). So now the question is is your combo box unbound? I think
you
should copy/paste here the DLookUp that you placed in the text box
so
I
can
see it. Perhaps, something is wrong there???


Typical reasons for #NAME?
Make sure that the field specified in the control's ControlSource
property
hasn't been removed from the underlying table or record source.

1. Check the spelling of the field name in the control's
ControlSource
property.

2. If you specified an expression in the control's ControlSource
property,
make sure that there is an equal sign preceding the expression.

3. Check for missing references...


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
Okay, I went there, but I don't understand what this has to do
with
the
textbox giving me the error "#Name?". I am new at this so please
break
it
down for me. I will go over what I have done so far with you
again:

I have two tables established. One holds the contact info for the
members
and the other is just for the membership types and fees..

Table: Members
Fields: MemberID - numeric primary key (autonumber), Organization
Name,
Street Address, Phone, etc. etc.

Table: Membership Types and Fees
Fields: MembershipID - numeric primary key (autonumber),
Membership
Type,
Membership Fees (three fields only)

These two tables are not linked in any way. I want to create a
form
to
have
the information come together. Specifically, my problem is that I
want
the
form to have a combo box to choose "Membership Type" and then
have
the
"Membership Fees" automatically inserted into the text box next
to
it
in
currency format. I want this selection to be specific to each
record
in
the
form and I also would eventually like to have this information
available
to
do a Mail Merge in Microsoft Word.



"Gina Whipp" wrote:

Amy,

No I don't mean References... my fault, please press the Code
button
and
go
to Tools... References in the Module code window behind a form
or
report.
Doesn't matter which one they are the same no matter which one
you
select.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in message
...
I have already checked the names of the fields and tables and
all
is
as
it
should be. When you say References, do you mean Relationships?
References
is
not an option under Tools while I am in design of my form.
When I
go
to
relationships, there is nothing there.

Is there another way to do this?

"Gina Whipp" wrote:

Amy,

Perhaps check references... go to design of any form or
report
and
under
Tools... References... and resolve any that are MISSING. If
none
are
missing, check to confirm the names of all fiedls and tables
in
the
DLookUp
function.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
Okay, I looked and I actually had it named "Fees".

Is there any other reason why this doesn't work?


"Gina Whipp" wrote:

Amy,

When you get a chance to look at it, you can't name the
text
box
any
name
that is included in the function. Please name it
txtMembershipFees.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
I named the text box Membership Fees, I think. I am at
home
now
so
I
can't
rember exactly. What should I look for when I get back?

"Gina Whipp" wrote:

What sis you name the text box?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote in
message
...
Hi Gina, it did not work I get "#Name?" in the box
instead
of
the
price.

"Gina Whipp" wrote:

Amy,

Yes, it should go in the Control Source, could be I
forgot
to
type
that.
And the DLookUp I provided should work, post back if
it
doesn't!

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"amy2876" wrote
in
message
...
Hi Gina, thank you for your response.

Yes, I do have the spaces in there. I did not
realize
that
it
can
cause
issues, but thanks for letting me know.

Membership Types and Fees is the table
MembershipID is a numeric field and is also the
primary
key
Membership Type is the second column in this table
Membership Fees is the third, not Currency. I just
had
the
format