Check box control of text box "is visible" propert

[pete61uk]

Hi,

In MS Access 2000, Forms-[Event Proceedure]: getting the is visible property of a text box to change using a check box (its properties true/false with false the default).

The "on-click" event works fine. However, when moving between recordsets on the form it remains visible despite in the new/following recordset the check box property is "false".

Any suggestions would be welcome

[SteveF]

Try the Oncurrent Event
if (it needs to be visible) then
tickbox.visible
else
tickbox.visible = false

[pete61uk]

Hi Steve,

Thank you very much for your reply.

Typically, my logic slower than I can type for assistance, I have already realised my error and correctly placed the event proceedure as you suggested.

Sometimes, it appears, in formulating the question the solution bites you!

The error, should anyone be interested, was in placing the event on the control and not on the form.

Thanks again Steve.

Another, more complex problem, is that of cascading combo box lists. I've seen a good example where the list is restricted according to an earlier combo selection, but in this each lists' records are held within a seperate table.

I have seen none where a single table is used for all records from where the list needs to be restricted to only those relevant.

In this I am assuming an on Update proceedure to specifiy specific records from within the table but have not found any examples.

Further complicating the issue(?), there are 3 combo boxes, 1 on the Main Form and 2 on a subForm.

Any suggestions welcome