>I have a grid I am using to capture date in. The first four columns in the grid are bound to the table. I want the fith column not to be bound to any column in the table. Instead I want to populate it with a value based on one of the bound columns.
>
>For example:
>
>CustomerNo
>Reg No
>Make
>Color
>Name
>
>The column name is not part of the fields in the table the grid is based on. I want to use the customerNo to look up the name and place the name value in the textbox of column1. I want this to automatically be updated when the CustomerNo in the grid has a value.
>
>Is this possible or will I have to make name part of the table?
>
>Thanks in advance
You can use a LOOKUP function as a controlsource for the name column.
If it's not broken, fix it until it is.
My Blog