Hi - I currently have a form, called form1, with a last name and first name lookup field.  The lookup fields arepopulated from a single line field on another form, called form2.

I am trying to figure out some scripting that will allow me to have the first name lookup field, on form1, autofilter so that when a last name is selected only the corresponding first name will be displayed.

(For example, if I have Bob Jones entered on form2, then when I select Jones from form1 I want the first name lookup field to autofilter so it only shows Bob.)

Thank you for any scripting help.