Open Specific Record

[ap1971]

I have a form which displays multiple records of a table (Named Base). I
want to add a button link to open another form and display only the
information for an individual record. The form I want to open is actually a
form/subform where information is pulling from the two tables. The tables
have a one to Many relationship. Table "Base" being my primary because it
holds individuals names and Ids. Table "Point" is the many because my
individuals can have multiple points. I am using Command Wizard to create a
button. I choose open the form and find specific data to display. I matched
the fields on ID. Like another user posted, my button takes me to the form,
but does not go directly to the matching Individual, only the first record on
the form.

Table 1 - Base (Fields ID, NameLast, NameFirst,Division)
Table 2 - Points (Fields: LinkID, Comment, Date)

Using Access 2007

 

[Jeanette Cunningham]

Hi ap1971,
please post your code.
Would you explain how the base table is related to the points table.
I doesn't appear that the ID field from Base is in Points as a foreign key
for the one to many relationship.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia