I am creating an access database.
1. I need on main form to be able to add code number, model number, and date (default value set in table).
2. have 1st subform display records that already exist that have same code number as being entered.
3.2nd subform- display all records based on query of 3 tables.
you will see I have 2 forms: data entry form and data entry form2.
Identical except 1st form has in private sub form _load -//I use code- DoCmd.GoToRecord,,acNewRecord
In 2nd form in property sheet-under data-//I have Date Entry set to True.
first question: Is one way better for this application?
second question:When I add a record – I still have to hit refresh button to have new record display
in second subform- ( is there a way to have it refresh when I hit add button?)
3rd question:I have to recreate this for access 2003- Will anything be different?
Last question?
Would you have any suggestions to improve this or correct any problem you see?
The database to download is on wikisend-at:
http://wikisend.com/download/949030/twoforms database.accdb
( i will check back in about 8 hours)
thank you,