display a value associated with a control on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Back
Top