Separate Form

Jun 23, 2015
Reaction score
Hi All

I hope that someone can help me, I am very new to access and need some assistance.

I am trying to create an database to log issues and have one form that records the main information about an issue (Records). from this I would like a second standalone form for adding notes (Notes).

The structure for the database is very simple and only has 2 tables; Record and Notes. these tables are relationally linked with the RecordID field from the Records table to the RecordsID in the Notes table with a one to many link.

The problem I have is that when I click the button on the Records form it open the Notes form but the information is not linked between the 2 so notes get added to the Notes table which are not linked to the Records table.

If anyone can hep me that would be great.

Thank you in advance.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question