Hello, I am new at this and wandered if someone could help me with a little problem that I can only figure out part way.
I am helping out a charitable organization by setting up for them a small Access database that would print receipts for donations we receive. I have a Donors table with and would like my receipt entry form (which will store the information in receipt table) to have one list combo box (for the donorID field) for which it would list a few columns of my donors table, and when I choose a specific donor, their first name, last name and all the address fields would automatically be seen. I am able to only get one field to work like that but not the rest. I looked through the Northwind database that comes with Access and tried to follow what is seen in the orders form (that is exactly what i want but without the shiplabels) I looked at the Me!coding in VBA and trying to apply it, but I have a feeling that I am missing something.
Anyways, if anyone can help and point me to the right direction I would really appreciate it. We need to send out almost a years worth of receipts by next week and right now I am using combo boxes for each field and have to check the address with the names.
Thanks and hope to hear something soon,
Yari.
I am helping out a charitable organization by setting up for them a small Access database that would print receipts for donations we receive. I have a Donors table with and would like my receipt entry form (which will store the information in receipt table) to have one list combo box (for the donorID field) for which it would list a few columns of my donors table, and when I choose a specific donor, their first name, last name and all the address fields would automatically be seen. I am able to only get one field to work like that but not the rest. I looked through the Northwind database that comes with Access and tried to follow what is seen in the orders form (that is exactly what i want but without the shiplabels) I looked at the Me!coding in VBA and trying to apply it, but I have a feeling that I am missing something.
Anyways, if anyone can help and point me to the right direction I would really appreciate it. We need to send out almost a years worth of receipts by next week and right now I am using combo boxes for each field and have to check the address with the names.
Thanks and hope to hear something soon,
Yari.