Prev: Data Type in Design View
Next: multiple back-ends
From: TedMi on 10 Feb 2010 17:23
As Gina says, you need to create a form whose data source is the table in
question. Display the form in datasheet or continuous view. On one of the
fields of the form, establish a double-click event that executes this code:
DoCmd.OpenForm FormName:="YourFormName", View=acNormal,
WhereCondition:="[ID]= & txtID

Where YourFormName is designed to display a single record from your table
(presumably with more detail than displayed in the datasheet view), txtID is
the name of the control holding the unique identifier of the row on which
you clicked, and [ID] is the name of the field in the underlying table that
holds this identifier.

This method will limit the single-record form to the one record identified
by ID. If you would to allow the user to navigate to other records in
single-record view, use this instead:
DoCmd.OpenForm FormName:="YourFormName", View=acNormal, OpenArgs:=txtID

Then in the Load event of YourFormName, execute this code:

If Len(Nz(OpenArgs, "")) > 0 Then
Me.Recordset.Clone.FindFirst "[ID]=" & OpenArgs
Me.Recordset.Bookmark = Me.Recordset.Clone.Bookmark
End If
Good luck!

-TedMi

"Gina Whipp" <NotInterested(a)InViruses.com> wrote in message
news:%231bK5apqKHA.5896(a)TK2MSFTNGP04.phx.gbl...
> TES,
>
> Not from table view but it can be done using a form. You can create a
> form
> to look like your table and place a hyperlink on it to open another form,
> with something like...
>
> DoCmd.OpenForm "YourFormName"
>
> Tables are meant to just hold the data not interact with it.
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "TES" <TES(a)discussions.microsoft.com> wrote in message
> news:269F0D04-8E77-4CB1-9E20-3734FDFE1E25(a)microsoft.com...
> I would like to have a link in one of the columns in my table view that
> will
> take the user to that record displayed in a form view. Is this possible
> to
> do in an existing base?
>
> Thanks.
>
>


First  |  Prev  | 
Pages: 1 2
Prev: Data Type in Design View
Next: multiple back-ends