Form linked to table record

[Will_BPP]

Hi all,

Completely new to access and slowly learning the skillset to build a database. The one aspect I cannot get to grips with is linking a form and its associated buttons to a certain row on the table. To add some context I have created a form titled "overview" which gives a snapshot of the important data from the table and on that form are 5 buttons which take you to another form that captures more data for that specific button title i.e. "finance". The problem I have is that once you click on a button it links to record one on the table and not to the record the overview form is currently on. What is the solution for this?

Any help on this is much appreciated, thanks.

[CJ_London]

are 5 buttons which take you to another form that captures more data for that specific button title i.e. "finance".

what code are you using?

if it is docmd.openform, one of the parameters is the WHERE parameter. You need to complete this with something like

PK=" & me.PK

[pbaldy]

More on what CJ is suggesting, in case the data type is not numeric:

http://www.baldyweb.com/wherecondition.htm

[Will_BPP]

Thank you both, this is exactly what I needed in terms of pointing me in the right direction of learning the WHERE parameter and the Macro etc for buttons. Thanks again.