Re: Select record in dataset - go to different form

Tech-Archive recommends: Fix windows errors by optimizing your registry

This example assumes one of the 5 fields in the search form is the primary
key - a Number type field named "ID". Adjust so it uses your actual field
name:

Dim strWhere As String
strWhere = "[ID] = " & Me.[ID]
DoCmd.OpenForm "Form2", WhereCondition:=strWhere

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"julie_b" <julieb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:662E6D30-D36A-464A-BFE7-4BCCA6458486@xxxxxxxxxxxxxxxx
>I have a search form that returns data in a subform in dataset view. The
> search results dataset shows 5 fields (summary level). I want to be able
> to
> select a record from the dataset search results and then click a "details"
> button to open a new form that will display more information about the
> selected record.
>
> I've gotten as far as creating a clone of the recordset so I can select an
> individual record. I can't seem to get the rest to work...


.

Quantcast