Show field based on previous field value

[davegri]

OP is original poster, which is you.
Please provide information requested in post #14. It would shine a light on what's going on. We're all stumbling in the dark here so far. Without more input from you, this is a dead end.

[forskare]

Gentlemen

As per the request, here's a layout of the table and the form.

Again,

The user makes a selection ('Homeowner', 'Renter', 'Landlord', 'Other') in the HRLO control or control1.

If the user selects 'Renter' or 'Landlord', Controls 3,4,5 become visible

If the user selects 'Other', control 2 becomes visible.

If the user selects 'Homeowner', nothing happens

[davegri]

As per the request, here's a layout of the table and the form.

I expected to see the images from your Access objects, not Excel sheets. Your images are no help at all for solving the Access problem you have presented.
Do you have anything that you have developed with Access?

[forskare]

OK, so enlighten me. What will a pic of the form tell that the excel I posted will not?

[davegri]

What will a pic of the form tell that the excel I posted will not?

It shows that your form textboxes are, in fact, bound to the table.
The right side of the form is overlaid, so I can't tell if HRLO is a combo box.

The user makes a selection ('Homeowner', 'Renter', 'Landlord', 'Other') in the HRLO control or control1.

When you say this, is the user making the selection from the table, or from the form?
What is the rowsource for HRLO control? What events are defined for the HRLO control?

We could save a GREAT deal of time and avoid the 20 questions style back and forth if you would post the database here. Then we could post images back explaining what we see as the solution.

[forskare]

Davegri,

Granted, my terminology may well have produced some confusion but none the less, code was suggested. You came into this thread knowing that so why did you ask these questions?

It shows that your form textboxes are, in fact, bound to the table.

When you say this, is the user making the selection from the table, or from the form?

What is the rowsource for HRLO control? What events are defined for the HRLO control?

Those are questions which have no bearing on what code to write. For the execution, yes. But the code itself, Nope! Why? Because code was suggested and none of your posed questions were mentioned.

Asking to see a form so you can see whether or not the control is a combo box tells me you don't know what you're talking about. Either that or you like to be antagonistic.

[CJ_London]

@forsake - dave is not being antagonistic, he is trying to help. In order to to help he needs some background to the situation. Hence the questions. We are all here to help where we can and we freely give what time we have to do so. But being unclear about what 'things' (objects) are called - controls/fields etc makes helping difficult resulting in '20 questions' - which is not an effective use of time. Your initial post refers to fields - fields are in tables, not forms - so from the get go we were heading off in the wrong direction. Your response in post #3 was antagonistic, and post #6 was equally vague in terminology. If you persist in being vague you will find the number of responders willing to help will drop off dramatically.

I take from your latest responses that the code works - in which case you should mark the thread solved - see the thread tools dropdown on the green bar at the top of the thread. It took 11 posts to get to what appears to be a satisfactory solution. The remaining 10 being at best 'challenging'. It should only have needed 3 or 4 at worst - particularly as this is a common question and a simple google/bing of your question would of produced many links to examples of similar requirements.

Good luck with your project

[Uncle Gizmo]

Greetings,

HRLO is a drop down list field which will have 4 choices: Homeowner, Renter, Landlord and Other.

If HRLO = 'Renter' or IF HRLO ='Landlord' Then show Field1, else IF HRLO = 'Other', Then show Field2 What is the syntax for this?

Thank you

Ken

The problem is your question does not make sense. Hence you are getting replies which assume you are a beginner. The replies are designed to ferret out more information, and possibly educate you.

Sent from my Pixel 3a using Tapatalk