Help on declaring a variable that holds its values 1

[JunglesMcBeef]

G'day,

I have created a type and created an array from that type in the general declarations. I have 2 event procedures invoked with a respective command button each. The first procedure fills the array with the current text box values on the form (only one record ie one element of the array). I want my array to be able to hold the values between calls so I can use the second procedure to write the contents of the array to the table after using the first procedure to fill the array with many items. What I guess I am trying to say is whether or not you can declare a static variable outside of a procedure and what to declare it as. Or can anybody suggest a better way to get around this?

 

[PHV]

Have you tried the Public instruction ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[JunglesMcBeef]

Yes, that didn't work. I think the fact that it is an array might be causing the problem, but i'm not sure.

 

[PHV]

Have you tried the Public instruction in a Module

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[JunglesMcBeef]

Yeah it gives me the same error message. I am going to change it so it writes to the table directly for each record when the procedure is fun, it will only take some rearranging of my code. Surely there is some better way to get this functionality working though?

 

[PHV]

Yeah it gives me the same error message
Which error ? Where ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[JunglesMcBeef]

Actually you were right with putting it into a module. The coding works fine now. I had just forgot to delete it from the other declarations.

I also have another question if you are willing to help, when I run a report based on a query related to these entries I cannot get a calculated field to work in the report. I am using a text box with the expression:
=Sum([Quantity]*[Price]*0.1 + [Quantity]*[Price])
When the report is run the box returns: #Error

Any ideas on why this may happen?

 

[PHV]

Take a look at the DSum function.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[JunglesMcBeef]

Works a treat now mate, cheers.