View Full Version : Opening specific form for record selected


rhay
04-05-2001, 07:39 AM
I've got another question for you all:

How do I open a form based upon the record selected?

I have a combo box that is linked to a list of records, depending on the record, it uses a unique form. How do I open a record in it's specific form?

Thanks,

Robert

Pat Hartman
04-05-2001, 05:16 PM
I presume there is some column in the table that you can use to identify the record type. You must include this column in the recordsource of the combobox. Then in the double click event of the combobox, you can code a case statement to check this column and open the appropriate form. Remember that the column index of the combobox is zero based. Therefore the third column would be referenced as YourCombo.Column(2).