Filling a field#2 based on select field#1
I have a Select field on a form that uses a recordset.
When I select that field, I would like another field on the form to be automatically filled in from data in that recordset (or another recordset filtered on the data from that select field).
I know it involves onchange and a script, but I can't figure out the script to use.
Any suggestions?


