I am creating a form where in short, a user will input measurements of products for quality inspection. At the moment I have label captions stating what the measurement should be and it's tolerance. The length is the only dimension that changes depending on product. Currently, I have it so the user will select a product from a combobox, and I want the label to update with the length associated with the product. I have a table that lists each products length.
I've attempted writing the following code on the OnChange property for the Product combobox.
Me.LengthLabel.Caption = Me.Product.Column(3)
I get a null error when I attempt to do this. I'm sure I'm missing something pretty simple, as I'm very new to Access!
Thanks so much!!
I've attempted writing the following code on the OnChange property for the Product combobox.
Me.LengthLabel.Caption = Me.Product.Column(3)
I get a null error when I attempt to do this. I'm sure I'm missing something pretty simple, as I'm very new to Access!
Thanks so much!!