Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating a form that updates/edits access database 1

Status
Not open for further replies.

valicon

MIS
Joined
Sep 26, 2000
Messages
125
Location
US
I would like to create a form that will allow me to add, edit and delete records in a multi-table access database. Can anyone point me to a site that can give me the basics on how I can code this? Thanks.
 
Access will do it for you.

1. Go into query design view and create a query that incorporates all the fields you need from the different tables and then save it.

2. Click the query name to select it.

3. Look on the toolbar for the icon with the lightning bolt through it (If no toolbar click view, toolbars, database).

4. Click the little arrow next to it and select autoform.

5. Modify the form in design view for field lengths, etc.

Good Luck!

Feel free to post again if you need some more help.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top