Field Data

[Lois]

Hi,
how do i get the description field (circled in red) to automatically input the correct info when the Nº is selected from the Nº combo box on the attached doc. i cant upload the database as it is too big...

thanks

[alansidman]

In your query that is used for the No. Box lookup, the columns are numbered from left to right beginning with zero, one, two, etc.

With your form open in design mode, type directly into the description field

=NoFieldName.Column(x)

where x is the column containing the description.

BTW. If you run a compact and repair and then zip your file, you will probably get it under the minimum required size for uploading.