thanks Its just what I need

There is only 1 issue that won't work on 2003 is the part that records the "Betting Agency" and "ID" it uses data validation in a list to find the item, in the past i have not got this to owrk but will see if i can work it out.

Those people with 2003 give it a try and tell me what does not work so i can try and fix it.

Its not a matter of it not working.
What happens is I get a Box rolling up saying that Excel doesn't recognize the Format of the Program , and can't open it.

I know Data Validation can be added in 2003 but i think it needs 2003 to do it, i have added a link on where to find it.
http://www.keystonelearning.com/res...alidation_rules

Instruction
1) Select E12 go to Data Validation in the Allow box select "list" in the source box put this in =Database!$AH$2:$AH$50 then press "OK"

2) Select E28 go to Data Validation in the Allow box select "list" in the source box put this in =Database!$AH$2:$AH$50 then click "Error Alert" tab and uncheck the box press "OK"

3) Select Z28 go to Data Validation in the Allow box select "list" in the source box put this in =Database!$AJ$2:$AJ$50 then click "Error Alert" tab and uncheck the box press "OK"

When this is all done save the document it should work now.

The only other thing is i removed code on the database sheet to reduce the size of the file so the formulas only go down to 2000 not 50000 you will have to extend them if you want more.

Nice one.
It Opens now.

The previous program was .xlsm and this one is .xls

Thanks Shaun.
Even though I may not use it soon, I appreciate you donating your services for free, which you do so often.
I hope God Blesses you and your Dreams and Goals come true for you and your family.