Return value of a Frame into an Append Query (1 Viewer)

[tinyevil777]

Good afternoon, hope Christmas and New Year went swimmingly for you all.

I've got an unbound form which on select a Command button, appends the data into a table. This works fine.

However, i've now added an unbound frame into my form, and i'm trying to append the selection in this frame, but it won't. It returns a blank field.

In the query, i'm using...

Expr1: [Forms]![NewPO]![Frame11]

Where am i going wrong?

Thanks in advance for your help!

Thomas

 

[Mr. B]

Create a Public Function in a Module to return the value of your frame.

Public Function GetFrameValue()
GetFrameValue = Forms!NewPO!Frame11
End Function

Then in your query use:

Expr1: GetFrameValue()

 

[tinyevil777]

When i try to run the query, it returns a 'Undefined function in 'GetFrameValue' in expression' message.

Have i missed a trick?

 

[Mr. B]

The function must be created in a Module, not in the form module and must be defined as public.

That is really all there is to it.

 

[tinyevil777]

The function is definitely in it's own Module, and not in a form module.

Please see the images attached to demonstrate this issue.

Any further help would be greatly appreciated!

 

[Mr. B]

You need to rename your module. You cannot have the module named the same as the function.

 

[tinyevil777]

Ah, didn't realise that. That's cracked it, thanks alot for your help!

 

[missinglinq]

The function is definitely in it's own Module, and not in a form module.

Two questions:

1) What is the name of the Module that the GetFrameValue() resides in? It cannot be the same as the Function because this upsets the Access Gnomes no end and causes them to throw all kinds of errors.

2) What in the world is a programmer in Wales doing writing code for the Norfolk Naval Shipyards, assuming that this is the NNS in Norfolk, Virginia?

Linq ;0)>

 

[tinyevil777]

1) What is the name of the Module that the GetFrameValue() resides in? It cannot be the same as the Function because this upsets the Access Gnomes no end and causes them to throw all kinds of errors.

I named the module the same as the function, that was the problem, i wasn't aware of that fact! Will learn from my mistakes!

2) What in the world is a programmer in Wales doing writing code for the Norfolk Naval Shipyards, assuming that this is the NNS in Norfolk, Virginia?

I must be having a moment of blissful ignorance... enlighten me?