DLookup!!

[Carly]

I have a form which updates a table but some of the textboxes have Dlookup functions in them and these do not update.

For example, I enter the Cost Centre and a Part Number. This then looks up the part number in another table and enters the description and UOM automatically.

But...

When I look at my table the fields which contain the lookups do not update.

What do I need to do to update the table correctly?

Regards
Carly

 

[Mile-O]

As your control contains an expression, you cannot bind its value to a table. And as this is a calculated expression, ask yourself, do you really need it in your table?

As it is calculated, every time you open your form on each of the records in its recordset, the expression on the textbox will calculate the value for you.