Add new record in Subform when adding to main form

[Rhysd]

Hi All.

I am new here and a relative junior to Access 2007. I have created a database to capture routine daily checks to hotel rooms that are reference with an ID and date. However I have split the data into three tables, a Maintenance Table, a Housekeeping table and A Main table that houses the general info that is meaningfull to all three. I have been able to get the Main table to update the other two using a query and a form with subforms but when I add a record to the main form the Subforms do not go to a new record and I am constantly updating old records in the subform while adding new records in the Main form. Can I change this using a query or would VBA be better...please be aware I am a serious noobie to VBA.

Thanks all

 

[ted.martin]

Not quite sure I understand fully but if you were able to run an Append query when a ceratin event triggers in your main form, you will be able to automatically add records to any subform.

The key here may be to decide upon the Main Form event and then of course, what data do you want to add to the subform.

Hopefully this helps your thinking.