If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
changing forms
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? |
#2
|
|||
|
|||
changing forms
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". "danklebs" wrote: 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? |
#3
|
|||
|
|||
changing forms
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? "Dorian" wrote: 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". "danklebs" wrote: 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? |
#4
|
|||
|
|||
changing forms
On 7 Mai, 22:14, danklebs wrote:
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? 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? 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 |
Thread Tools | |
Display Modes | |
|
|