Form Question

[Ann]

I have a form that records all Maintenance on Printers and
PCs - These are the fields:

M/C no
User name
Report Date
Report Time
Problem Desc
Type (Internal or External)

If Internal then the fields are:

Int Eng name
Fixed (Yes or No)
Date Fixed

If the problem has to be fixed outside the extra fields
are:

Company name
Engineer name
Cost
Date returned


Some of the fields are completed if the nature of the
complaint is Internal - then there is no need to fill in
the external details and vice versa.
Is it possible that when I choose Internal that the other
External fields can be greyed out so that the person does
not enter by mistake??? and everything jumps past this
field???

Thanks in advance...

Ann (Dublin, Ireland)

 

[Roxie Aho]

-----Original Message-----
I have a form that records all Maintenance on Printers and
PCs - These are the fields:

M/C no
User name
Report Date
Report Time
Problem Desc
Type (Internal or External)

If Internal then the fields are:

Int Eng name
Fixed (Yes or No)
Date Fixed

If the problem has to be fixed outside the extra fields
are:

Company name
Engineer name
Cost
Date returned


Some of the fields are completed if the nature of the
complaint is Internal - then there is no need to fill in
the external details and vice versa.
Is it possible that when I choose Internal that the other
External fields can be greyed out so that the person does
not enter by mistake??? and everything jumps past this
field???

Thanks in advance...

Ann (Dublin, Ireland)
.

I'd make both the Internal and External text boxes or
controls Visible = False, then then Internal or External
is selected, After Update event would turn the appropriate
controls visible.

Roxie Aho
roxiea at usinternet.com

 

[Ann]

Hi Rosie

The problem with this is I have made the box a drop down
so that the user chooses either Internal or External so is
this still possible??

Thanks again

Ann

 

[Roxie Aho]

-----Original Message-----
Hi Rosie

The problem with this is I have made the box a drop down
so that the user chooses either Internal or External so is
this still possible??

Yes. In from design, Properties, format tab, make the
controls that you don't want the user to see until he/she
makes a selection Visible=False.

In the After Update event of the combo box add the code to
make the appropriate controls visible, something like

If cboChoose = internal then
Me.Internal Engineer.Visible = True
Me. Next control.visible=True
Else
Me.CompanyName.Visible =True
etc.
End if

Roxie Aho
roxiea at usinternet.com

 

[Ann]

Thanks a million Roxie!!

Ann (Ireland)

-----Original Message-----


Yes. In from design, Properties, format tab, make the
controls that you don't want the user to see until he/she
makes a selection Visible=False.

In the After Update event of the combo box add the code to
make the appropriate controls visible, something like

If cboChoose = internal then
Me.Internal Engineer.Visible = True
Me. Next control.visible=True
Else
Me.CompanyName.Visible =True
etc.
End if

Roxie Aho
roxiea at usinternet.com

.