Very Newbee Question

[yarym]

Hi! I'm learning Access right now, but really don't know how it should work. I created a table and set all the fields. I created a graphical form and laid out all the fields. Now, I clicked on command and it added a button. I want this button to get inputs form these fields and add them to the table. How can I do that. Please remember that I'm just starting with access, so I need detailed intructions.
Thank You

 

[PHV]

I'm just starting with access
Play with the wizards.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[yarym]

i got the button installed and found how to enter the expression. Problem is i don't know how to make it equal the input. Can you just tell me the proper expression?

 

[TheAceMan1]

How are ya yarym . . . . .

[blue] I want this button to get inputs form these fields and add them to the table . . .[/blue]

Thats a bit of a loaded question and also jumping ahead of your learning curve, as it [blue]requires whats called a Recordset and VBA code.[/blue] Are you ready for that?

Normally what you ask is not required except under special conditions. [blue]For the most part you'll always use a Bound Form.[/blue] Thats a form with controls that have their [blue]ControlSource property[/blue] set to the [blue]name of table fields.[/blue] [purple]When you change records in the form the fields are automatically saved.[/purple]

To instantiate a Bound Form, just use the Form Wizard (In the forms window, click [blue]New[/blue], or from the MenuBar [blue]Insert - Form[/blue] and follow the wizard.

To get a good basic understanding of Access that you'll need as a background and will always stay with you, grab your favorite beverage, have a sit down, and make sure you understand the following (this is the heart of any relational database):

Fundamentals of Relational Database Design Normalizing Tables Table Relationships

Also have a look at the [blue]FAQs[/blue] provided by [blue]PHV[/blue].

BTW . . . . [purple]Welcome To Tek-Tips![/purple]

See Ya! . . . . . .