Navigator button to prompt field choices

JoseQuiervo · Dec 9, 2003

On my navigator I would like a button to create a new document. However, what I want is for the user to click this button, it prompts them to choose what TelevisionType(primary field on the document) Sony, Phillips, or RCA, and based on that choice determines how the document is created.

There's a single document that contains all the necessary data for each brand, but depending on their choice determines what data shows (via hide whens). How can I do this?

pmonett · Dec 9, 2003

You could use a formula in the QueryOpen event that asks the question, and make the fields in the document take their values as result of the question.

Pascal.

ABOzIT · Dec 10, 2003

Another way is to put the following formula into the default value of your TelevisionType field:

@Prompt([OKCANCELLIST];"Specify Type";"Please specify the type of television";"";TelevisionTypes)

Make sure you have all the different types in the TelevisionTypes field and make it a Dialog List. The list values for the prompt are obtained from this field. The best way to get the values for this field is via a profile document. This way if your brands change you just change the profile document saving you having to recode the field. Heve a look in designer help for info on Profile Documents. They are a very handy and often overlooked tool

Hope this helps!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Navigator button to prompt field choices

JoseQuiervo

Programmer

pmonett

Programmer

ABOzIT

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor