If I get a request for a Parameter value when i open a form etc, and I don't know where it's coming from, is there a way to find where the request is coming from? Maybe through the Immediate window with VBA code?
99% of the time it means that you have spelled something wrong. The parameter message is telling you exactly what to look for. Basically Access is saying, "I cant find FrstName, so I'll ask for it. Please enter the value"
In reality it should be FirstName for example.
So....
Look at the data for the form. I'm betting it is a query.
Richard thank you for correcting me on the video reference. I lost track of that one. That was definitely a better reference.
Avigder WebeberOP
@Reply 3 years ago
First of all, thank you very much
I want to explain, the question comes because I have a very complex software with a form that consists of several queries and some of them have, for example, the field "StudentId". Sometimes when I want to upgrade the system and I make the code stop in the middle so after the code has stopped running I get the request to enter a dynamic field, and it matters to me to know from which query it requests it. So I asked if there is a way to know this by VBA code
Scott Axton
@Reply 3 years ago
Avigder I'm sorry but I'm not quite following you on what you are trying to achieve with your data. Most of the time, even the most complex processes can be broken down into many smaller, easier, sub-processes.
I actually try and avoid parameter queries and "request" or obtain the information directly in the forms I'm working with. It is easier to control and verify information there.
The queries should be used to extract or consolidate the information you are wanting to see. You are asking questions about your data.
Scott Axton
@Reply 3 years ago
The Value From a Form video may help you to get the information you are looking for.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 5.