Use Public variable in Query 1

[TimTDP]

In Access 2000, I have created the variable:
Public intProductId as integer

how can I use this in a query?
I need to use it in the field of a query. I have an append query and I need to use the value of intProductId in the result.
I don't want to write an sql statement, because this will become quite difficult to manage

 

[SkipVought]

How is your variable assigned a value?

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[dhookom]

If I understand, you need to write a small function that returns the value of the public variable.

Public Function GetProductId() As Integer
    GetProductID = intProductId
End Function

You can then use GetProductID() in your query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]