Link Table to Form

[DaveTief]

I have developed a Microsoft Database Access 2010 Table and associated Form



I open both the Table and Form and a separate tab appears for each, then I can switch from either the table or form by clicking the tab.

In the Table screen I select a record, as an example, record number 1926.

How can I link this record with the form so that when I select the form tab, record 1926 is shown?

[Bob Fitz]

I don't think you can and I can't imagine why you would want to. Tables are only for storing data.

[orange]

I agree with Bob -- your question seems to need more context. Why do you want this?

A table is where the data is stored. A form is typically used to provide the user a controlled way to see/add/change data.
With a form the developer can add code to validate an entry, can substitute codes for names etc.. so the user of the form can not simply access and change/delete entries randomly with nobody aware such changes were made. The form with designed code can actually prevent/guide the user according to established "business" rules.

Good luck with your project

[Geo21]

I agree with the 2 above. Though, if you must do this, try the "On Got Focus" Property of the form. Then, type the code:

Dim rs As Object

If SysCmd(acSysCmdGetObjectState, acTable, "Table Name") <> 0 Then
    Set rs = Me.RecordsetClone
    rs.FindFirst "ID = " + [Tables]![Table Name]![ID]
    Me.Bookmark = rs.Bookmark
End If

Assuming ID is the unique value to distinguish your record.

Also, the If...Then checks if the table is open.

[June7]

Sounds like a Split form might serve your needs.