I have a question about macros in access. what are the steps that we should follow to save the data that we are entering in the form to the already created table?
Generally speaking if your form contains bound controls then the record would be saved when you have completed filling in all required fields and you close the form or move to another record in the form, so not much usually needs to be done to accomplish this it is usually automatically handled by the MS Access program itself.
Thank you for your reply.but what do you mean by bound controls? I guess I do not have them that's why I can not save the record. So, do you think that If I chance the command in the save button that the user should click on to save the record, that will work? So, If I use coding instead of regular steps?
You have me lost. How did you create the form with a wizard or did you just create a new one and place controls on it?
If you used a wizard and you selected your table and the fields then there shouldn't be a problem, unless you selected a query that is not updatable instead of a table.
If you just kicked it off with a new form then placed controls on it then see the above and try to use a wizard, once the form is created with a wizard you can view it and it's properties and you can see everything the wizard designed for you.