If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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 |
#22
|
|||
|
|||
New User - Field population based on combo box selection
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 |
#23
|
|||
|
|||
New User - Field population based on combo box selection
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 |
#24
|
|||
|
|||
New User - Field population based on combo box selection
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 |
#25
|
|||
|
|||
New User - Field population based on combo box selection
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 |
Thread Tools | |
Display Modes | |
|
|