go to field based on if statement

[mleiser]

Hope I'm in the right part of the forum. Here's what I need to do.

You tab to Field 1 and enter the data.

Based on Field 1 (if such and such) you either go to Field 2 for entry or Field 3.

If you go to Field 2, based on the data in Field 1 you may either be sent to Field 3 where the data from Field 2 is copied but you are alklowed to change it, or based on that data in Filed 1 you may skip Field 3 and move on to Field 4.

I hope I made it clear.

Any help on that?

Thanks,

Mike

[mleiser]

I have a database with Field 1 and Field 2. On a report, the body contains information per record including Filed 1 or Field 2. It's based on an IF statement. How do I get the report (if possible) to show either Field 1 or Field 2 based on that condition.

Mike

[LaRetta]

Please provide a small file showing an example of the logic and data and these four fields so we can understand the purpose and context of your request. Thank you. :^)

[mleiser]

Field 1 = When a child is going to camp

Field 2 = Childs bunk for July (only if they are coming in July)

Filed 3 = Child bunk in August (only If they are coming in August. Also, if they are coming in August, automatically insert Julys bunk into August bunk with the ability for the user to change the August bunk. That's because most campers coming for July and August stay in same bunk)

Field 4 = next filed - whatever it is

Thanks

[Lee Smith]

Automatic message

This topic has been moved from "The Presentation Layer → Conditional Formatting" to "The Presentation Layer → Layouts".

Please do no double post. I have merged your two topics.

[comment]

How do I get the report (if possible) to show either Field 1 or Field 2 based on that condition.

Try conditionally formatting both fields, so that one of them is displayed in 500-pt font size (which makes it invisible).

Based on Field 1 (if such and such) you either go to Field 2 for entry or Field 3.

I don't think that's possible in version 9. In later versions, you could use script triggers to override the layout's tab order.

[mleiser]

In conditional formatting can you tell me how to set the size to 500 pt. I know there's a function where you give the field and the size, but in the conditional formatting you're already in that filed.

Mike

[comment]

Format > Conditional… > More Formatting… > Size: 500

[Lee Smith]

mleiser

I just sent you a private message.

[mleiser]

Thanks. S Time, I'll look now