Creating a lookup form for data
Posted on 2004-09-23
Here's what I'm trying to do:
Has bound controls showing 1 record at a time. Has a quick find button. When the user hit this I want another form to pop-up (Dialog - Form2)
Show a list box or grid with all records, a text box, and a combo box with all fields, ok and cancel buttons.
The user can search and select one record. When they click OK, then Form 1 will move to the record the user selected.
I have to be able to do with with many tables, so I figured I'll pass a dataview to the form, but I don't quite understand how I could pass the id of the selected record back to form 1. Once I have the id, I know how I can find the position in my current dataset. It's just being able to get the id, and being able to use it when form2 closes and run my sub to move to the position.
Please help :)