Update table

[brmk]

I have a text field where the control source is a DBLookup expression. It works fine...Now, how do I store the value found in the DBLookUp in my table?

 

[Tony C]

You need to do the following: -

1. Open the form in "Design View".
2. Display the Form Properties (click View/Properties)
3. Click on the Tab "Data" and ensure that the Table Data
Source is specified, e.g. "Table01".
4. Click on the Combo Box.
5. The Properties Page will have been updated, Select the
Record Source from the available list.

HTH.

Tony C.

-----Original Message-----
I have a text field where the control source is a

DBLookup expression. It works fine...Now, how do I store
the value found in the DBLookUp in my table?