More dropdown issues 07

[JBurlison]

I Have a form that has a dropdown of records, i want it to automatically jump to a record on update, um still new to this its probably easy but i cannot figure it out for the life of me. in office 2003 i could select "Find a record based on the value I selected in my combobox.". is there a macro or a VBA code that i could use to do this? maybe some sample code to give me a general idea of how i need to do it, or maybe it can be done by macro

 

[pbaldy]

The 2007 wizard still has that option, but it will only appear if the form is bound to a table.

 

[JBurlison]

how do i bind it to a table?

 

[pbaldy]

Change the form's record source property to the table.