Display a query parameter through Dialog Box

[proggy]

How can I display a query parameter through a Dialog Box?
I have a function GettidValue() which I want to display through dialog box and also store that valu in a new table to be retrieved later.
any help is really appreciated,
thanks,

 

[MapMan]

It's been awhile, but in query builder I used to put the question in brackets as the "field name" and it would prompt for input.

ie. [What item number to you want to order?]

HTH, MapMan

Assume nothing, question everything, be explicit not implicit, and you'll always be covered.

 

[proggy]

thanks but.. that i have done already...
what want is a dialog box should pop and say you entered " 56" where 56 is passed to a parameter query as u said above..

 

[MapMan]

Here you go, give this a whirl...

Assumptions...
[tt]The textbox is name NetBlkEnd[/tt]

Concept...[tt]
Add code to the LostFocus event of your control to display the contents of the control[/tt]

Code...

Private Sub NetBlkEnd_LostFocus()
    Dim a$
    a$ = MsgBox(NetBlkEnd, vbOKOnly, "You Entered")
End Sub

HTH, MapMan

Assume nothing, question everything, be explicit not implicit, and you'll always be covered.