Access Forms Submit Button

[eddiesvoicebox]

Morning All,

I have a 'Team Change Database' that is used to process amendments to thew staffing data we hold. On previous forms that i have built i linked the form to the table using control sources. But i have found that this sometimes creates blank records in the table where people input the wrong thing or start an entry and then close the form etc. I am looking for a way around this ? ? ?
In the past i have used a method whereby i pull the original record from the table into a holding table and then use an update query from the form fieldsto update the record. This unfortunately is not possible in this case. I did try append but this only works if there is already a record in the table.

Im not sure if this makes any sense but basically i am looking for a submit button that actually submits the data from the form.

Any help (as always) would be greatly appreciated.

Many thanks in advance for any time taken on this problem.

Regards

EddiesVoicebox

 

[KenReay]

Hi

While not trying to dissuade you from Unbound forms, you can do this using bound forms

see

docmd.runcommand acCmdSaveRecord
docmd.runcommand acCmdUndo

in help

and consider writing a vb function to verify the data input by the user,



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[PHV]

An usual way is to enforce all the validation rules in the BeforeUpdate event procedure of the bound form.

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

 

[eddiesvoicebox]

Thanks for your quick responses guys. I have looked into the docmd.runcommand acCmdSaveRecord & docmd.runcommand acCmdUndo commands (have never used before) and it looks like its going to dojust what i need.

Again thanks

EV

 

[ZmrAbdulla]

With all respect to PHV's post
I always recomend to read RoyVidar's FAQ for these type of requirements.

Form - looping thru the controls faq702-5010

________________________________________________________________________
Zameer Abdulla
Visit Me
A sweater is usually put on a child when the parent feels chilly.