Linking a cell/field in one form to link back to another form on click

[hardoc]

Hi All! I'm very new to Access and created a very simple Form where I can enter individual contact information like Name, Address, etc.. This information than is linked and populates the main Form that lists all the contacts and their information in rows.

I want to be able to click on the person name on the main Table (list of all the contacts) and have it take me to the individual contacts information Form.

I hope this make sense... I've done some searches online and the only instructions I can find to do anything like this is to create another Form and have that link to the individual contact Form on click... but this is not ideal for me. I'd much rather just be able to click from Table to Form.

Any advice would be greatly appreciated! Thanks

[ranman256]

put a button on the form, the click event will be

docmd.openform "f1Contact",,,"[id]=" & txtID

this will open the single record form, using the ID field in the record the cursor is on.

[hardoc]

Hi thanks! I mistyped though.. I want to have a button or some way to take me from a Table to a Form... I'll edit my post.. .but thank you for the quick response!

[Bob Fitz]

Hi thanks! I mistyped though.. I want to have a button or some way to take me from a Table to a Form... I'll edit my post.. .but thank you for the quick response!

You should never need to open a table. Tables store data. You should be using forms to add/edit the data in the tables.

[hardoc]

Hi Again - Can you tell me where to add this... I can't find "click event" I created another form so now it is form to form.

[hardoc]

Thanks.. I wasn't able to get a form to have the look and feel of the table that I wanted but I was able to play with it a bit and now have a form I'm happy with so I appreciate your advice and will only work in the form view and leave the table alone going forward