If at all possible, avoid using the wizard to create forms. Open a blank form in design. Bind the form to a table. Then add each of the fields you wish to have using the field listing. You can only bind a form to a single table or query. If you have more than one table you wish to input to contemporaneously, then you will need to create a separate form for each table. Make these separate forms sub forms and place them in the main form. If you have created relationships between the tables, then you should be able to link the Parent form to the child forms. Here is a good resource on all these topics.
http://www.databasedev.co.uk/general.html
I would urge you to pick up a book on Access as this will help you to picture these concepts and expand your understanding.
As to testing your database, I personally do not have time or inclination to do that. I am willing to guide you in your endeavor and answer questions as issues arise, but I will not test your work for you.
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks