display a value associated with a control on a form

T

TanaTheIntern

I am building a database to record bird survey data. I have a table that
includes two fields, CODE and COMNAME. I would like it to work so that when
I enter the bird species CODE into my form control box, the bird's common
name (COMNAME) displays next to it on the form, as a safety check that I am
entering the correct species.

I imagine I need to create a text box on the form that is bound somehow to
the CODE control, but I don't know how to write an expression to do this.
Any suggestions?
 
Top