Synchronisizing Sub-Form field To Text-Box

[vdanelia]

Hello Dear Friends, I have a question about Synchronizing Sub-Form Field To a Text-Box!



I have a Main form on which i use Sub-Form and text-boxes (Sub-form is Synchronized with main table data)
I want to display Snumber and Barcode from Sub-form in Unbound text-boxes, I used the function: =DLookUp("Barcode","CODE") the field is displayed but it is not synchronized I think there must be add something like : "[DATAID]=" & [ID], but can't implement it correctly.

Thank you In advanced

[RuralGuy]

Yes you will need a WhereCondition clause to use that method: http://www.mvps.org/access/general/gen0018.htm

[vdanelia]

Not Synchronizing, When navigating the records on sub-form the records displayed in the text-box is not the same...

The fields are in the Sub-Form: (Sub-Form is based on The table [CODE])
DATAID - Number (FK) (This field is Synchronized (Linked) with Main Table [DATA])
Snumber - Text
Barcode - Text

On The form I have two Unbound Textboxes: Smunber, Barcode