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!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do i get report to show fields dependant on which y/n box on form?

Status
Not open for further replies.

Malta393

Technical User
Apr 8, 2002
18
EU
I have an Orders form with 3 Yes/NO boxes
box1-called-PO Recd & Impt
box2-called-Cleared
box3-called-OrderPaidStatus

If box 1&2 marked "no"-report to show Req No
If box 1 marked No and box 2 marked "Yes"-report shows Purchase Order Amount
If box 2&3 marked Yes then hidden box on form appears and when this is marked yes along with 2&3-report shows Invoice Amount.

I need the user to state beginning and ending dates and which manager and account code for the report

Complete novice-so detailed guidance req guys & gals

Help appreciated
kaz[wink]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top