Adding new Record issue

[yosik20]

Simple question regarding one to many relationship form:

1. I have main form, lets say 'authors', and another form, lets say 'books'. The relationship is one-to-many (many books for one author – connected by author id).


2. From the Authors Form, For each Author record, I put a Command Button. clicking the Button at a specific Author opens the books Form - List of the books for the specific Author I clicked (I connected them using the Access Macro Wizard which Generated Macro opening the books Form with the author key arguments.

So far I had it well.

3. the problem is when I'm in the books Form, and I want to add new record with new book details, I would like Access to automatically paste the current Author ID from the Form (which is connecting key) to the new record

Any suggestions?

[kennejd]

I'm not sure I'm following you, but you could set the default for authorId to referenct the form and field you want.

[yosik20]

OK thanks.
1. At What event should I integrate the code? BeforeInsert? OnLoad?

2. This is a Tabular Form with many Books records. In such a tabular form, with numerous recordes, how do access know that what AuthorID field I mean? there such field in every record

[kennejd]

I'm not sure I can help you without seeing a sample of your database...can you post it? My visualization powers are a little weak this morning...