Small white one,,, I login first form a first learn to survive under the student id, display the data in this form should be how to operate?

CodePudding user response:

=DLookUp (" [name] ", "the examinee information table", "student id=" & amp; [Forms]! [the examinee information query]! [xh1])
After the search display # mistake how do I set the student number a specified value can be found out

CodePudding user response:

Student id is the text type

CodePudding user response:

=DLookUp (" [name] ", "the examinee information table", "student id=" & amp; CRH (34) & amp; [Forms]! [the examinee information query]! [xh1] & amp; CRH (34)

For textual data, quotes, ordinary quotes error-prone, here with CRH (34) in two head, can perfect alternative quotes,

CodePudding user response:

Upstairs, positive solutions to quotes, if it is a value type need not add references,