I'm new to Access (2007) so i'm going a very long-winded way about making a formulae sheet.
Basically I've written a set of formulae out in Excel and want to transfer this so that it'll work in Access.
I've written a form which has various combo boxes and a seperate query which references the form.
What is supposed to happen is the user selects text from a drop down box on the form; the query references to the selected text and outputs a value for whichever the choice is (this value is output from a seperate 2 column table).
Now this all works fine when I'm writing it, as I ran the query after each new piece of info I input to prevent me wasting my time. Then I saved the file, closed and reopened the program and upon reopening and trying it I have the parameters giving me grief asking me to enter parameters for the referenced box.
Nothing had changed apart from the program was closed so why is it saying I have a false reference point?
Help please!!
Basically I've written a set of formulae out in Excel and want to transfer this so that it'll work in Access.
I've written a form which has various combo boxes and a seperate query which references the form.
What is supposed to happen is the user selects text from a drop down box on the form; the query references to the selected text and outputs a value for whichever the choice is (this value is output from a seperate 2 column table).
Now this all works fine when I'm writing it, as I ran the query after each new piece of info I input to prevent me wasting my time. Then I saved the file, closed and reopened the program and upon reopening and trying it I have the parameters giving me grief asking me to enter parameters for the referenced box.
Nothing had changed apart from the program was closed so why is it saying I have a false reference point?
Help please!!
