update form field

[Davide]

I have two tables:



client(id, name, markup)
forecast(id, client.id, client.markup, total)

I have created a form on the second table, forecast.
The client can be selected by means of a combox from the first table, client.
Now I would like the corresponding markup to appear in the client.markup field.
I have tried with an expression:

=DLookUp([client]![markup];[client];[client]![ID]=[client])

but it does not work and a get an error: #type!
Any suggestions? thanks

[Bob Fitz]

On the forecast form you would have a combo box to select the client. It would have a column for the ID, a column for the Name, and a third column for the markup. In the After Update event of the combo box use code to assign the value of the third column to the markup on your form. Something like:
Me.[NameOfMarkupControl] = Me.[NameOfCoboBox].Column(2)

Column(2) is actually the third coulm because the numbering starts with 0.