Help with data source - jump to record.
-
I'm trying to create a form that lets me select the item from a list, then click "edit" and a new form opens with the selected record from the previous list and displays that records attributes. I can't figure out how to do this without editing the SQL query to accept a parameter. That wont work for my purpose because I need the user to be able to add/delete from that table, and sql search will only return the 1 item. Logic Flow: -User picks item from SQL driven listbox. -Clicks "Edit", value passed for selected listbox item. -new form loads (should be on current record, not record 1 which requires the user to navigate back and forth to find the right item.) I've passed the information needed to the new form, and I know that is making it correctly. I am just not finding any kind of "jump to record" type command for the binding navigator, or the binding source. Thanks.