Linking to record in form view
in [Tables]
|
Prev: Data Type in Design View
Next: multiple back-ends
From: TES on 10 Feb 2010 13:21 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.
From: Steve on 10 Feb 2010 13:48 You can create a search on your form that will display a selected record. Steve santus(a)penn.com "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. >
From: Stop$teve on 10 Feb 2010 16:15 "Steve" <notmyemail(a)address.com> schreef in bericht news:uKekdGoqKHA.5940(a)TK2MSFTNGP02.phx.gbl... > You can create a search on your form that will display a selected record. > Good answer $teve... but Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 11.000 pageloads... it's a shame !!) For those who don't 'agree' with this mail , because $teve was 'helping' with his post... We warned him a thousand times... Sad, but he is not willing to stop advertising... He is just toying with these groups... advertising like hell... on and on... for years... oh yes... and sometimes he answers questions... indeed... and sometimes good souls here give him credit for that... ==> We are totally 'finished' with $teve now... ==> Killfile 'StopThisAdvertising' and you won't see these mails.... Arno R
From: Gina Whipp on 10 Feb 2010 16:19 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.
From: TedMi on 10 Feb 2010 17:14
As Gina says, create a form to query your table and display it in datasheet or continuous form view. On one of the text boxes of the form (e.g. LastName), establish a double-click event that executes this code: DoCmd.OpenForm FormName:="YourFormName", View:=acNormal, OpenArgs:=txtID Where txtID is the tex box on your datasheet view that contains the unique identifier of the row on which you clicked. In the Load event of YourFormaName, insert this code: If Len(Nz(OpenArgs, "") > 0 Then Me.RecordSet.Clone.FindFirst "[ID]=" & OpenArgs Me.Bookmark = Me.RecordSet.Clone.Bookmark End If Where [ID] is the name of field in the TABLE which is the datasource for the form. An alternative method: DoCmd.OpenForm FormName:="YourFormName", View:=acNormal, WhereCondition:="[ID]=" & txtID Then you don't need anything in the Load event of the form. Differences: With the first method, the user can navigate over the datasource of the form. In the second, the form is limited to displaying the one record identified by the value of ID. "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. > > |