Focus a field

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Hi,

I have a file the record of which has 3 fields.
I created a form “DefaultView Property†which is “Continuous Formsâ€

There are 3 fields which can be left empty without any problem. However, if
the first one has data then the third one has to be filled in, obligatorily,
and vice versa.

So the programme should not allow to the user a) to focus on other record
and b) to add a new record when one of the above mentioned cases stands.


Thanking you in advance for your collaboration
 
Open your table in design view, and set a validation rule on the table (not
on a field) such that if Field1 is not null then field3 must not be null.

The validation rule to enter in the Properties box (not lower pane) in table
design would be like this:
([Field1] Is Null) OR ([Field3] Is Not Null)

More info:
http://allenbrowne.com/ValidationRule.html
 
I wrote the command in the properties of the file (validation rule) but it
did not work.

Allen Browne said:
Open your table in design view, and set a validation rule on the table (not
on a field) such that if Field1 is not null then field3 must not be null.

The validation rule to enter in the Properties box (not lower pane) in table
design would be like this:
([Field1] Is Null) OR ([Field3] Is Not Null)

More info:
http://allenbrowne.com/ValidationRule.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Simon said:
Hi,

I have a file the record of which has 3 fields.
I created a form “DefaultView Property†which is “Continuous Formsâ€

There are 3 fields which can be left empty without any problem. However,
if the first one has data then the third one has to be filled in,
obligatorily,
and vice versa.

So the programme should not allow to the user a) to focus on other record
and b) to add a new record when one of the above mentioned cases stands.


Thanking you in advance for your collaboration
Click to expand...
Click to expand...
 
Keep trying. You can do it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.
Simon said:
I wrote the command in the properties of the file (validation rule) but it
did not work.

Allen Browne said:
Open your table in design view, and set a validation rule on the table
(not
on a field) such that if Field1 is not null then field3 must not be null.

The validation rule to enter in the Properties box (not lower pane) in
table
design would be like this:
([Field1] Is Null) OR ([Field3] Is Not Null)

More info:
http://allenbrowne.com/ValidationRule.html

Simon said:
Hi,

I have a file the record of which has 3 fields.
I created a form “DefaultView Property†which is “Continuous Formsâ€

There are 3 fields which can be left empty without any problem.
However,
if the first one has data then the third one has to be filled in,
obligatorily,
and vice versa.

So the programme should not allow to the user a) to focus on other
record
and b) to add a new record when one of the above mentioned cases
stands.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top