display a value associated with a control on a form

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

form combo box accessing two tables not showing correct results 1
CommandName? 2
Combo box referencing parent form and sibling subform? 5
Return a value from one column using an array and a single row 1
open form datasheet view with defined number of prenumbered blank records 7
auto populating a form 1
VBA code for unbound column in combo box 3
Search through a table using multiple Criteria from a Form 1

Top