Query using field on Form

[charcurley]

I have a form for inputting billing information. I want to push a button and have the bill print out. I have the bill report (using answer.db from a query) on the Object Explorer of the Print Bill Button. I can make it pick up the invoice # if I ask for the invoice #. I need it to automatically pick up the invoice number from the form.

(I am an Access user and new to Paradox any help would be greatly appreciated)

 

[Guest_imported]

Presumably the invoice# is a field on the form. With the form in design mode, click on the invoice# field and note the object name in the status bar (may be something like invoice__). The object name is usually the field name as in the table, but with underscores instead of "illegal" characters (spaces, brackets, etc).
You can assign a variable to the value of the invoice, e.g.
method pushbutton(..etc....). e.g. if the field name is "invoice__" then the code would look like this:

var
invNum longing
endVAr

invNum = invoice__.value

..etc...

HTH
Padraig

 

[charcurley]

Thanks! That was the info I needed. Appreciate it