Recent content by LordofTzeentch

woops knew i forgot to put something The error occurs at prm.Value = Eval(prm.Name)

The current program i have has a combo box to grab a value from a table the program then looks this value up in a query and places the cost of the item in the variable Point. The code i have got works on 4 of the other combo boxes that are doing exactly the same but it doesnt work on this i get...

Excellent it work thanxs alot its much apreciated :)

Ive just tried that and got Run-time error 3061 Too few perameters. it stops as soon as it gets to Set rst = CurrentDb.OpenRecordset("QryMagicPoints")

Hi im pretty new to all this and need some help Im creating a program for a wargame that i play that will create army list s for me. I have everything how i want it but Im having trouble figuring out how you get a value from a query into a variable the code i have atm is Dim Point As Integer...