Re: Link form to table

  • Thread starter Thread starter John W. Vinson
  • Start date Start date
J

John W. Vinson

hello all,

i am using ms access 2007 and im still learning it, i want to create a
customer database (table) and i want to create a form that i can use to enter
a new customer into the database. i am able to create the customer table
however i need help regarding how to link the form to the table in order to
insert the customer Name,Number,Adress etc in the form and to be directly
sent to the table. How is it done?

thnx
Click to expand...

Use the table - or, better, a query based on the table - as the form's
Recordsource.

There is an "Auto Form" wizard if you open the table in design view, it should
give you a starting point.

You might want to look at some of these resources; Crystal's tutorial video
would be a good start:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
HI John thnx for all the resources but i still wasn't able to do it :S i was
able to create a form in design form with adding text boxes and a button
however i wasn't able to give the action( needs coding i think) to the button
so that when pressed would insert the texts in the text boxes to the table.
John W. Vinson wrote:
Click to expand...

Why do you need a button?????

What do you want the button to do?
 
I need the button to make the form more user friendly because it will be used
by inexperienced users who do not know access so i want to make each function
with a button. How can i add buttons that do different things when clicked
example add new record?
Click to expand...

Open the Form in design view.
Make sure the Toolbox is visible (it normally will be in design view, and it's
on the ribbon in 2007/2010).
Use the Command Button tool.

The toolbox wizard has some common choices (move to new record) available, or
you can write your own Macro or VBA code in the button's Click event.
 
Back
Top