hide and show a field

[KAnoe]

I have a field that I would like to hide [uwl_ba_type]. I would like the
field to only be seen if the text entered into field [uwl_wast_type] is BT.

This way when the user puts in the waste type of BA for Battery the
[uwl_ba_type] field will appear and the user can then input what type of
battery it is.

Thanks

Keith

 

[Ofer]

On the after update event of [uwl_wast_type] field you can write the code

me.[uwl_ba_type].visible = (me.[uwl_wast_type] = "BT")

If you move between records in the form, you should call this after update
sub from the on current event of the form

 

[KAnoe]

Do I need to set the format of the [uwl_ba_type] field to Visible to No??
As it is now you can see the field when you open the form.

Just a note the form is what I call an add to form. It is used to only add a
new record.

Thanks

On the after update event of [uwl_wast_type] field you can write the code

me.[uwl_ba_type].visible = (me.[uwl_wast_type] = "BT")

If you move between records in the form, you should call this after update
sub from the on current event of the form

I have a field that I would like to hide [uwl_ba_type]. I would like the
field to only be seen if the text entered into field [uwl_wast_type] is BT.

This way when the user puts in the waste type of BA for Battery the
[uwl_ba_type] field will appear and the user can then input what type of
battery it is.

Thanks

Keith

 

[Ofer]

You don't need to, you can put this code on the on current event of the form.

On the after update event of [uwl_wast_type] field you can write the code

me.[uwl_ba_type].visible = (me.[uwl_wast_type] = "BT")

If you move between records in the form, you should call this after update
sub from the on current event of the form

I have a field that I would like to hide [uwl_ba_type]. I would like the
field to only be seen if the text entered into field [uwl_wast_type] is BT.

This way when the user puts in the waste type of BA for Battery the
[uwl_ba_type] field will appear and the user can then input what type of
battery it is.

Thanks

Keith

 

[KAnoe]

GOT IT THANKS!!!!!

Do I need to set the format of the [uwl_ba_type] field to Visible to No??
As it is now you can see the field when you open the form.

Just a note the form is what I call an add to form. It is used to only add a
new record.

Thanks

On the after update event of [uwl_wast_type] field you can write the code

me.[uwl_ba_type].visible = (me.[uwl_wast_type] = "BT")

If you move between records in the form, you should call this after update
sub from the on current event of the form

I have a field that I would like to hide [uwl_ba_type]. I would like the
field to only be seen if the text entered into field [uwl_wast_type] is BT.

This way when the user puts in the waste type of BA for Battery the
[uwl_ba_type] field will appear and the user can then input what type of
battery it is.

Thanks

Keith

 

[Ofer]

ANY TIME

GOT IT THANKS!!!!!

Do I need to set the format of the [uwl_ba_type] field to Visible to No??
As it is now you can see the field when you open the form.

Just a note the form is what I call an add to form. It is used to only add a
new record.

Thanks

On the after update event of [uwl_wast_type] field you can write the code

me.[uwl_ba_type].visible = (me.[uwl_wast_type] = "BT")

If you move between records in the form, you should call this after update
sub from the on current event of the form


:

I have a field that I would like to hide [uwl_ba_type]. I would like the
field to only be seen if the text entered into field [uwl_wast_type] is BT.

This way when the user puts in the waste type of BA for Battery the
[uwl_ba_type] field will appear and the user can then input what type of
battery it is.

Thanks

Keith