Form Auto Filling

  • Thread starter Thread starter Viswanathan S
  • Start date Start date
V

Viswanathan S

Hi all,
I have a table with Columns A, B and C and also many other
Fields.

I have another Table T2 A1, B1, and C1 where values in T2,
A1 can have only those values of A and similarly for B and
C.
Now I have a data entry form. I want to enter the unique
A1 (that is available in table T1, A) and want the values
B1 and C1 back fed automatically, from T1 B and C
respectively.

How can I do that?
Thank you.
Viswanathan S
 
Hi,

You could use a Dlookup Function to retrieve the data, and populate the
fields you need, you could write the code on the AfterUpdate Event of the
field that is the key to the search, and then assign the results over.

I would recommend this only for a few fields, and would also recommend that
you index the tables to speed this process up.

I hope this helps

Regards

Mark


This information is provided "As IS", and expresses no warranties or
confers no rights.
 
Back
Top