Multiple Fields in a FOrm

[SD DIamond]

How do I get several fields in a FORM to automatically
pull up the correct data based on an entry I make in one
field. i.e. I enter a product ID and the descriptive
fields of cut, color, clarity etc. . .fill from that
record in the Products table?

 

[grep]

You could use dlookups in the AfterUpdate event to set the values for
the other fields.

Cut = dlookup("Cut", "Products", "[ProductID] = " & ProductID)
Color = dlookup ("Color", "Products", "[ProductID] = " & ProductID)
Clarity = dlookup ("Clarity", "Products", "[ProductID] = " & ProductID)

I'm not sure it's the most efficient way to handle it, but it work.

grep

 

[SD Diamonds]

Thank You I will try that!

-----Original Message-----
You could use dlookups in the AfterUpdate event to set the values for
the other fields.

Cut = dlookup("Cut", "Products", "[ProductID] = " & ProductID)
Color = dlookup ("Color", "Products", "[ProductID] = " & ProductID)
Clarity = dlookup ("Clarity", "Products", "[ProductID] = " & ProductID)

I'm not sure it's the most efficient way to handle it, but it work.

grep

How do I get several fields in a FORM to automatically
pull up the correct data based on an entry I make in one
field. i.e. I enter a product ID and the descriptive
fields of cut, color, clarity etc. . .fill from that
record in the Products table?

.