On 4 Nov 2004 04:59:43 -0800,
ta*******@yahoo.com (anita) wrote:
You could use DLookup to check. For example in the
Form2.Field3.AfterUpdate you could write:
if IsNull(DLookup("Field1", "Table1", "Field1=" & txtField1 & " AND
Field2=" & txtField2 & " AND Field3=" & txtField3")) then MsgBox "Bad
Boy!"
What this does is lookup any value (I would use the PrimaryKey value)
from Table1 given the values of the 3 fields. If any of these fields
are text rather than numbers, you have to wrap the values with single
quotes like this:
"Field1='" & txtField1 & "' AND...
If Table1 has many rows, say > 1000, DLookup may be too slow, and you
should write your own query to essentially do the same. Of course you
will have Table1 properly indexed with a unique index across the 3
fields.
-Tom.
Hello Everybody
I have two tables(and the corresponding forms) with following fields
Table 1 (Form1)
Field1
Field2
Field3
Table 2 (Form2)
Field1
Field2
Field3
Field4
......
Field10
When the user enter the values for Field1,Field2,Field3 in Table2 or
rather in Form2, I want to do a validation check for those values from
Table1. If the values match with the corresponding records in Table1,
it should let the user to proceed to Field4 in table2, else it should
through an error message. (Please note that the Table1 is data entered
before Table2)
Is it possible to do this, if so can annybody please help me through
with this problem.
Thanks for all your help.
I realy appreciate it
Regards
