New to Access Forms

[harry1987]

I am new to Access forms,but created a form from scratch.Now I need how to save data from this form onto tables.Please help.

[June7]

Simplest method is to bind the form to table or query - set the form RecordSource property. Then bind data controls to fields - set their ControlSource property.

This is basic Access functionality. Might want to review http://www.rogersaccesslibrary.com/ or some other tutorials. Any introductory book should cover this.

[harry1987]

My question was wrong, the problem is I dont want tables to control the form,instead the data filled into the form should be stored in a blank table.Since I created form first and then the tables,I am finding it difficult to insert this data into tables.Right now the form and table are not connected.

[June7]

Don't see how that changes my advice.

Move to New Record row to enter data to a new record in table.

If you don't bind the form and controls, will need LOTS of VBA code to save data.

[Missinglinq]

If you don't bind the form and controls, will need LOTS of VBA code to save data.

And LOTS of VBA code to do just about everything thing else that needs to be done! Access is designed to provide rapid development through the user of Bound Forms, and using this type of Form means that the vast percentage of tasks are handled pretty much automatically.

Several developers I know, experienced in Visual Basic database development and Access development, estimate that development, using Unbound Forms, by highly experienced developers, takes two to three times as long, using Unbound Forms, as it does when using Access and Bound Forms. That's because with Bound Forms, Access takes care of the 'heavy lifting,' but with Unbound Forms, the developer has to write code to take care of just about everything.

If you insist on using Unbound Forms, you'd be far better off using a straight VB or C++ front end with a SQL Server or Oracle back end.

• You can create an EXE file which gives total protection to your code/design
  
• You can distribute the db to PCs without a copy of Access being on board
  
• Your data security is far, far better than anything you can do in Access

Linq ;0)>