Unable to fined Reference Field

[John Lee]

Good day folks,

I'm trying to reference a field in a form from a report, the problem I'm having is that the code keeps saying that it can't find the field in question, but it does exist, I've checked several times and can't work out why it is not finding it, I've attached the snapshots I took in the word document.

Any assistance would be most appreciated.

 

[arnelgp]

how do you reference it?

you can use a unbound textbox on the report and add code to the report's Load event:

private sub Report_Load()
Me!Unboundtextbox = Forms!TheFormToReference!TheTextboxToReference
end sub

 

[John Lee]

how do you reference it?

you can use a unbound textbox on the report and add code to the report's Load event:

private sub Report_Load()
Me!Unboundtextbox = Forms!TheFormToReference!TheTextboxToReference
end sub

Hi thanks for your response, I've found the problem and its now resolved

 

[Gasman]

Good day folks,

I'm trying to reference a field in a form from a report, the problem I'm having is that the code keeps saying that it can't find the field in question, but it does exist, I've checked several times and can't work out why it is not finding it, I've attached the snapshots I took in the word document.

Any assistance would be most appreciated.

Nothing attached?

 

[Gasman]

Hi thanks for your response, I've found the problem and its now resolved

So please say how you found it and then fixed it.
That could help someone with the same issue in the future.?

After all, that is what these forums are for. Not just to take, but give and take when you can.

 

[John Lee]

So please say how you found it and then fixed it.
That could help someone with the same issue in the future.?

After all, that is what these forums are for. Not just to take, but give and take when you can.

I did upload a word document with the code in it, however the problem was that I was referencing the wrong form, on checking several times and going through code a bit at a time, which was how I found my mistake.

 

[Gasman]

I cannot see any attachments in this thread, but thank you for your solution.
Always easier to post code within code tags, unless it is a huge block, as site will restrict number of characters that can be posted.

 

[DHookom]

The OP hasn’t posted enough times that would allow him to attach a file.

 

[Gasman]

The OP hasn’t posted enough times that would allow him to attach a file.

I thought that was just for links?
The O/P in this thread and this one of his is new and they only have 7 posts, but managed to upload his DB in that posts and in his others?

 

[DHookom]

I thought that was just for links?
The O/P in this thread and this one of his is new and they only have 7 posts, but managed to upload his DB in that posts and in his others?

I expect I was confusing posts with urls vs attachments.