Creating a form to handle multiple new records

[jefflach]

Hello all - I've been using this forum (as a read only user!) for a while and finally came across a situation where I really couldn't find an answer to my question so here goes my first post. I have a database that is intended to handle project budgeting. The basic premise is that for everyone one project there are multiple "detail lines" that make up the external costs for the project (i.e. Software, Hardware, Consulting, costs). I have a form that asks users to populate the high level detail about the project (project name, department, sponsor, etc) which simply writes a new record for each project to a table. Simple enough. My problem becomes adding the detail lines for the project from a single form. I'd like the user to go from entering the high level detail to another form that lets them add up to 8 or 10 line items for each project. I tried using unbound controls and SQL (INSERT INTO) to write to the detail lines table but couldn't get the syntax right. Is there a simple way to do this? I can't seem to figure out how to allow multiple line items on one form and then write them to a table, and do it without writing blank lines for unpopulated fields... I've attached a photo of the form to give you the basic idea of what I'm trying to accomplish. Thanks in advance for any help!

[Robeen]

What I think you want is to create a 'Master Detail' Form.
Check this link:
http://office.microsoft.com/en-us/ac...101872705.aspx
Hope this helps!!

[jefflach]

Worked perfectly. I ended up creating a separate form as a continuous form to handle this in the long run since my screen became too cumbersome. Thanks for your help!

[Robeen]

You're welcome! All the best.