Current location - Trademark Inquiry Complete Network - Futures platform - After selecting the target field in the combo box in the ACCESS form, how to realize the automatic display of the corresponding field?
After selecting the target field in the combo box in the ACCESS form, how to realize the automatic display of the corresponding field?
I don't quite understand your question. Guess. ...

If you select the field 1 in the combo box A and want to automatically display the contents of field 2 in the text box B,

Attribute in text box b->; Data-> Write to data source: =DLookUp ("field 2 name", "table name", "field 1 name ="&; [combo box name])

If the field 1 is text, =DLookUp ("field 2 name", "table name", "field 1 name ='"&; [Name of combo box A]&"'")