Recent content by DalGal

I guess I'm not sure what you are saying. They are 3 separate fields. I use member ID in other tables and link it via relationship with the MembersList table. I guess the MemberID is not really needed as I COULD key on the CenterID,FirstName,LastName, but--I only very loosely understand...

In the CenterName combo box, they enter the center name, and it stores the center id. The table is: CenterID, MemberID, FirstName, LastName, Notes, Active

It is ok to have a duplicate first name, OR last name, OR CenterID, but not all 3 in one record.

Correct

It is a data entry form. The user enters the CenterName, which is a combo box and saves the CenterID. Then just the First name combo box and last name combo box, and a notes field. Hidden is the MemberID which is an automatic number.

I already have a primary key (member id) on table MembersList, but want to test for duplicates on a form where both first and last names are combo boxes before creating the record. so far I have the following as an Event procedure on the Before Update of the second combo box names Last Combo...

I think I got it now. thanks!

nope still doesn't automatically choose the first in the list

But now it will not choose the first loan when there are loan records. Is there a way to add that back?

But now, it is not automatically choosing the first in list when the center does have loans.

Thank you-it worked!

Woohoo!!! Thank you-It worked!!!

I have a list box on a form which pulls loans based on the center chosen in the first field on the form. It automatically chooses the first loan to prevent a non-record chosen. I am getting an error when I have a center with no loans. This is the code (Event Procedure) to choose the first-when...

Pat-I will try that-good info! I didn't know about the order and dummy accounts. I have both of those queries set up already. I've never done a union query so I'll look at that. Not sure where the thank you button is but Thanks!

Other note is I have centers. Each center has vendors. Each vendor has units and contributions. Each entry of units and/or contributions has a date. Tables are: Centers, Vendors, Activity Centers have a unique ID Vendors have a unique ID dates, units, and contributions are not unique...