Open a form view from datahseet view

[aintgotnone]

I want to be able to scan through the datasheet view of a particular table and open the record I choose from this table in a form (which is built on data from this datasheet). Is this possible? That is, is it possible to open a record in form view, from a datasheet view?

 

[RickSpr]

Sort of. You can't do it from the table datasheet, but you can create a form that opens in datasheet view, which you can make look very much like a table datasheet.

Even though it's shown as a datasheet, you program this form just like one that's in form view, to a large degree. Only controls bound to fields will show up in the datasheet--not command buttons, for example--but you could use a field's DoubleClick event to invoke code that opens the other form in form view.

Also, even though the datasheet shows multiple records at the same time, there is still only one current record, so you can use the current values of the datasheet form's controls to construct a criteria string that you pass in the OpenForm call. That will limit the opened form to displaying just the current record.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein