changing forms

  • Thread starter Thread starter danklebs
  • Start date Start date
D

danklebs

So I have a database that keeps track of tests for work. I need a form to
change based on a previous input in a form. So if the previous input is a 1,
then the form need to say one then and if that input is a 2 the form needs to
say something different. Is this possible and if so how would one do this?
 
You have not explained what you want very well.
Guessing what you might want....
You can store the value in a control in a global variable.
Do this in the controls AfterUpdate event.
In the Forms Current event you can examine this variable and then set
something on the form based on its value. The Current event is triggered
whenever you move to a new record.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
The database tracks tests that are performed. On the form to enter data,
there is a priority input cell for the test. If the priority is A then a
different input cell in the form needs to say one thing and then if the
priority is a B, the form input cell needs to say something else. Is this
possible?
 
The database tracks tests that are performed. On the form to enter data,
there is a priority input cell for the test. If the priority is A then a
different input cell in the form needs to say one thing and then if the
priority is a B, the form input cell needs to say something else. Is this
possible?
Click to expand...

I understand you have two fields on your form: [priority] and
[warning]?
So put in the ControlSource of field [warning] :
= iif([priority]="A", "One thing", "Something else")

The first "=" is needed. You need also to adjust the field names of
course.

This will not work if [priority] can have something else than "A" or
"B" (e.g. "C" or nothing) or [warning] needs to be a bound field.

Regards
Marco P
 
Back
Top