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 |
#1
|
|||
|
|||
New User - Field population based on combo box selection
Hello - I am new to Access and I am trying to create a database for
association memberships. I want to be able to select a membership type on a form from a combo box and have the membership fee automatically populate a field based on the selection. How do I do this? Please "dumb" your answers down as much as possible LOL! |
#2
|
|||
|
|||
New User - Field population based on combo box selection
Amy,
Assuming you have a table with Membership Type and Membership Fee on your form you could use the wizard to create your combo box. After you create your combo box you could have an unbound text field to capture the Membership Fee, using a DLookUp. If you need help writing the DLookUp then post back with the ComboBox name, the table with the Membership Type and Membership Fee and which field is the Primary Key in said table. -- 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 ... Hello - I am new to Access and I am trying to create a database for association memberships. I want to be able to select a membership type on a form from a combo box and have the membership fee automatically populate a field based on the selection. How do I do this? Please "dumb" your answers down as much as possible LOL! |
#3
|
|||
|
|||
New User - Field population based on combo box selection
Hi Gina! Okay, here is the info:
Table: Membership Types and Fees ComboBox Name: Membership Type Key: MembershipID Thank you for your help!! "Gina Whipp" wrote: Amy, Assuming you have a table with Membership Type and Membership Fee on your form you could use the wizard to create your combo box. After you create your combo box you could have an unbound text field to capture the Membership Fee, using a DLookUp. If you need help writing the DLookUp then post back with the ComboBox name, the table with the Membership Type and Membership Fee and which field is the Primary Key in said table. -- 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 ... Hello - I am new to Access and I am trying to create a database for association memberships. I want to be able to select a membership type on a form from a combo box and have the membership fee automatically populate a field based on the selection. How do I do this? Please "dumb" your answers down as much as possible LOL! |
#4
|
|||
|
|||
New User - Field population based on combo box selection
Gina, I think I should also tell you that I have set the Membership Fees to a
Currency Data Type. I am not sure if this makes a difference or not, but I thought I would mention it. "amy2876" wrote: Hi Gina! Okay, here is the info: Table: Membership Types and Fees ComboBox Name: Membership Type Key: MembershipID Thank you for your help!! "Gina Whipp" wrote: Amy, Assuming you have a table with Membership Type and Membership Fee on your form you could use the wizard to create your combo box. After you create your combo box you could have an unbound text field to capture the Membership Fee, using a DLookUp. If you need help writing the DLookUp then post back with the ComboBox name, the table with the Membership Type and Membership Fee and which field is the Primary Key in said table. -- 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 ... Hello - I am new to Access and I am trying to create a database for association memberships. I want to be able to select a membership type on a form from a combo box and have the membership fee automatically populate a field based on the selection. How do I do this? Please "dumb" your answers down as much as possible LOL! |
#5
|
|||
|
|||
New User - Field population based on combo box selection
Amy,
Was at a Client and just got back but will post a reply in a little bit. -- 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 ... Gina, I think I should also tell you that I have set the Membership Fees to a Currency Data Type. I am not sure if this makes a difference or not, but I thought I would mention it. "amy2876" wrote: Hi Gina! Okay, here is the info: Table: Membership Types and Fees ComboBox Name: Membership Type Key: MembershipID Thank you for your help!! "Gina Whipp" wrote: Amy, Assuming you have a table with Membership Type and Membership Fee on your form you could use the wizard to create your combo box. After you create your combo box you could have an unbound text field to capture the Membership Fee, using a DLookUp. If you need help writing the DLookUp then post back with the ComboBox name, the table with the Membership Type and Membership Fee and which field is the Primary Key in said table. -- 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 ... Hello - I am new to Access and I am trying to create a database for association memberships. I want to be able to select a membership type on a form from a combo box and have the membership fee automatically populate a field based on the selection. How do I do this? Please "dumb" your answers down as much as possible LOL! |
#6
|
|||
|
|||
New User - Field population based on combo box selection
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 fields are as stated above... Textbox name: txtMembershipFee =DLookup("[Membership Currency]", "[Membership Types and Fees]", "[MembershipID]=" & Me![Membership Type]) On another note, putting spaces in your Object and Field names causes you to have to bracket anything with a space. I try to avoid the extra key strokes by eliminating spaces in the befroe mentioned items. -- 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! Okay, here is the info: Table: Membership Types and Fees ComboBox Name: Membership Type Key: MembershipID Thank you for your help!! "Gina Whipp" wrote: Amy, Assuming you have a table with Membership Type and Membership Fee on your form you could use the wizard to create your combo box. After you create your combo box you could have an unbound text field to capture the Membership Fee, using a DLookUp. If you need help writing the DLookUp then post back with the ComboBox name, the table with the Membership Type and Membership Fee and which field is the Primary Key in said table. -- 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 ... Hello - I am new to Access and I am trying to create a database for association memberships. I want to be able to select a membership type on a form from a combo box and have the membership fee automatically populate a field based on the selection. How do I do this? Please "dumb" your answers down as much as possible LOL! |
#7
|
|||
|
|||
New User - Field population based on combo box selection
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 fields are as stated above... Textbox name: txtMembershipFee =DLookup("[Membership Currency]", "[Membership Types and Fees]", "[MembershipID]=" & Me![Membership Type]) On another note, putting spaces in your Object and Field names causes you to have to bracket anything with a space. I try to avoid the extra key strokes by eliminating spaces in the befroe mentioned items. -- 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! Okay, here is the info: Table: Membership Types and Fees ComboBox Name: Membership Type Key: MembershipID Thank you for your help!! "Gina Whipp" wrote: Amy, Assuming you have a table with Membership Type and Membership Fee on your form you could use the wizard to create your combo box. After you create your combo box you could have an unbound text field to capture the Membership Fee, using a DLookUp. If you need help writing the DLookUp then post back with the ComboBox name, the table with the Membership Type and Membership Fee and which field is the Primary Key in said table. -- 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 ... Hello - I am new to Access and I am trying to create a database for association memberships. I want to be able to select a membership type on a form from a combo box and have the membership fee automatically populate a field based on the selection. How do I do this? Please "dumb" your answers down as much as possible LOL! |
#8
|
|||
|
|||
New User - Field population based on combo box selection
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 fields are as stated above... Textbox name: txtMembershipFee =DLookup("[Membership Currency]", "[Membership Types and Fees]", "[MembershipID]=" & Me![Membership Type]) On another note, putting spaces in your Object and Field names causes you to have to bracket anything with a space. I try to avoid the extra key strokes by eliminating spaces in the befroe mentioned items. -- 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! Okay, here is the info: Table: Membership Types and Fees ComboBox Name: Membership Type Key: MembershipID Thank you for your help!! "Gina Whipp" wrote: Amy, Assuming you have a table with Membership Type and Membership Fee on your form you could use the wizard to create your combo box. After you create your combo box you could have an unbound text field to capture the Membership Fee, using a DLookUp. If you need help writing the DLookUp then post back with the ComboBox name, the table with the Membership Type and Membership Fee and which field is the Primary Key in said table. -- 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 ... Hello - I am new to Access and I am trying to create a database for association memberships. I want to be able to select a membership type on a form from a combo box and have the membership fee automatically populate a field based on the selection. How do I do this? Please "dumb" your answers down as much as possible LOL! |
#9
|
|||
|
|||
New User - Field population based on combo box selection
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 fields are as stated above... Textbox name: txtMembershipFee =DLookup("[Membership Currency]", "[Membership Types and Fees]", "[MembershipID]=" & Me![Membership Type]) On another note, putting spaces in your Object and Field names causes you to have to bracket anything with a space. I try to avoid the extra key strokes by eliminating spaces in the befroe mentioned items. -- 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! Okay, here is the info: Table: Membership Types and Fees ComboBox Name: Membership Type Key: MembershipID Thank you for your help!! "Gina Whipp" wrote: Amy, Assuming you have a table with Membership Type and Membership Fee on your form you could use the wizard to create your combo box. After you create your combo box you could have an unbound text field to capture the Membership Fee, using a DLookUp. If you need help writing the DLookUp then post back with the ComboBox name, the table with the Membership Type and Membership Fee and which field is the Primary Key in said table. -- 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 ... Hello - I am new to Access and I am trying to create a database for association memberships. I want to be able to select a membership type on a form from a combo box and have the membership fee automatically populate a field based on the selection. How do I do this? Please "dumb" your answers down as much as possible LOL! |
#10
|
|||
|
|||
New User - Field population based on combo box selection
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 fields are as stated above... Textbox name: txtMembershipFee =DLookup("[Membership Currency]", "[Membership Types and Fees]", "[MembershipID]=" & Me![Membership Type]) On another note, putting spaces in your Object and Field names causes you to have to bracket anything with a space. I try to avoid the extra key strokes by eliminating spaces in the befroe mentioned items. -- 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! Okay, here is the info: Table: Membership Types and Fees ComboBox Name: Membership Type Key: MembershipID Thank you for your help!! "Gina Whipp" wrote: Amy, Assuming you have a table with Membership Type and Membership Fee on your form you could use the wizard to create your combo box. After you create your combo box you could have an unbound text field to capture the Membership Fee, using a DLookUp. If you need help writing the DLookUp then post back with the ComboBox name, the table with the Membership Type and Membership Fee and which field is the Primary Key in said table. -- 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 ... Hello - I am new to Access and I am trying to create a database for association memberships. I want to be able to select a membership type on a form from a combo box and have the membership fee automatically populate a field based on the selection. How do I do this? Please "dumb" your answers down as much as possible LOL! |
Thread Tools | |
Display Modes | |
|
|