John Xerri
10-04-2006, 11:04 AM
Relatively new to databases. I have designed a few using tables, forms. reports etc and have a switchboard open up on start up. When entering details in the switchboard form I need to press enter to save the record.
I noticed that on some databases there is a button which you press to save the record.
Pardon me for being pretty dumb but how do I add this to my forms.
statsman
10-04-2006, 05:04 PM
On the toolbar there is a command button.
Click the button on the toolbar then click your form. Voila the command button apprears.
The wizard should start right away. One of the options in RECORDS is "Save Records.
John Xerri
10-05-2006, 11:59 AM
Thanks Statsman.
It's easy when you know how. Can I pick your brains again. When I created the save button and open up the switchboard I entered the details and click the save button. The record still shows on the page. Creating a next record button allows me to add a new record. Can I alter the macro to go to the next record automatically rather than have two buttons. This also allows the user to see that the record has been saved.
Alternatively, Do you have any suggetsions as to how the user knows the record has been saved.
If not thanks for the help, I can see how easy it will be to print, save , delete etc now.
statsman
10-05-2006, 12:50 PM
The best way according to your description is to put a save record button on the form. By clicking the button the user KNOWS they've saved it.
They then click the new record button to get a blank form.
I usually have two forms to do these things. The first is for entering new data only and is set to data entry. The second is just for viewing or updating the record and uses a search form to find the record you want.
John Xerri
10-05-2006, 02:11 PM
Many Thanks.
Sounds goood to me. I am staring to build databases at work and I am gradually getting there. The butons were the main problem and thanks for the help.