Form Help needed

[matt001]

Hi

I have created my Access Database. I have started to create a form.

I have a table called products the following fields in the product table is ProductCode, Product Description.

What I am wanting to do in the form I am creating is be able to type in the ProductCode then hit the tab button and it automatically brings up the product description in the product description field that corsponds with the productCode.

I know it can be done as I have done it before, but forget the steps.

Matthew

 

[pbaldy]

Include both fields in the source of a combo box. In a textbox:

=ComboboxName.Column(1)