VBA code/query for Donor Table

[iouu2]

We have two tables Donor and Donation (access).

Donor table consists of:
· DonorID, FirstName, LastName, Street 1, Stree2, City, State, Country, Zip and other personal information.

Donation table consists of:
· DonationID, DonorID, Date Received, Payment Method, Amoutn, ProgramID, CheckNumber
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
We are trying to create a query/code that will loop through our Donor table and look for a donors name, if that name is not found then a new random number is generated for the DonorID. If the name is found, the assigned DonorID number is inserted in the form/table.

Any advice/help is appreciated!

 

[ColinKJ]

Hi iouu2,

We are trying to create a query/code that will loop through our Donor table and look for a donors name, if that name is not found then a new random number is generated for the DonorID. If the name is found, the assigned DonorID number is inserted in the form/table.

Sorry iouu2, but you may need to clarify this further.