Updating a table with a form

[utzja1]

I'm a newbie to Access 2007, so let me apologize in advance if this question is extremely basic.

I have a table where I use a form to allow users to enter data to create a new record. I added a button to the form for the user to click when they are done entering all the required data. I've tested the form, and the data does get added to the table but I have to close the table and re-open it to see the new records. I'd like to have this data be visible when the user closes the form (most users will be familiar with EXCEL and will expect to see their work). I added a second button to the form for the user to be able to close the form, and I added a Requery command in front of the CloseWindow command thinking that before the form closed that the table would be updated. it doesn't appear to be working. Can anyone point me in the right direction? It seems like it should be a simple task but I am at a loss.

Thanks!

 

[Alansidman]

Is your form bound to your table? If so, you do not need to have the save button as Access does this automatically. I am guessing that you probably have a subform that shows the table and this is what you are referring to that you want your users to see? I am not sure of the value here as the users can see what they entered in the form and Access updates it. I get that users have been using Excel and like to see the spreadsheet arrangement, but Access is not a spreadsheet and how the data is stored is not relevant. How it is retrieved is the essential issue once entered. Just my opinion and thoughts.

 

[utzja1]

Thanks for the prompt reply.

In the Property Sheet for the form, the Record Source is populated with the title of the main table. Is this equivalent to the form being bound to the table? I've seen the term in other posts and found it confusing since all my reference books only referred to bound controls.

From your reply, I understand that a bound form will automatically save user input to the table. If I want use the same form for someone to enter the same basic set of data for multiple items, would I not need a button for the user to advance to the next new record?

Thanks for your patience.

 

[Alansidman]

You could add a command button to say New Record. The Command Button Wizard will allow you to do this. Alternatively, you could use the arrows at the bottom of the form

Sounds like your table is bound.

 

[utzja1]

Thanks! I think I'm wasting time by worrying about the users perception of the table. I think with a central switchboard and task-specific forms to edit data or generate reports, end users will never need to see the table. Your suggestions make a lot of sense.

Thanks again.