Displaying Subform for new record...

[chrisveale]

Hi.

I have been given the task of maintaining a system developed by someone else.

I am relatively new to Access proper but have programming and database knowledge.

I am using Access 2007.

I have a form that retrieves information form the database which is fine. In that form there is also 2 subforms that gets data from other tables based on the id of the record on the main form.

however...

When a new record is added on the main form, the subforms dissappear (I'm assuming because there is no matching records or anything at this stage).

What I need to know is...

How do I allow those forms to be displayed when the user is adding a new record to the main form so they can populate those at the same time?

Currently they have to add the new record first then re-query the database for that record whuch then displays the sub forms so they can add that. Its just a shame its a two step process, and I want to try and tidy that up.

The subforms are driven from a database query so I am wondering if it could hopefully be as simple as changing the join type of the query?

Hopefully I have explained myself enough that you know what I am talking about

Any thoughts would be much appreciated.

 

[JCShort]

I've got the exact same problem. I'd love to hear feedback.

My plan is to create another form to capture the information and write code to insert the data into all of the necessary tables.
The user will simply click the "Add Record" button, but instead of assigning the add record command to the button, I'll have the on-click event to open the "Add Record" form. I'll put a button on the "Add Record" form that will trigger the code.

I was planning on doing this today, but I wanted to check this forum first to see if there was an easier way.

Any input would be much appreciated!