Save the record after a field is populated

[kysterathome]

Hi All,

How do I automatically save a record after a field has been populated?

The situation: I have a lookup btn in my frmData that pops up a frmSearch. Upon double clicking my choice is frmSearch, the last field in frmData (a combo box txtInfo) gets populated with the data I double-clicked in the frmSearch.

After this, I would like the frmData to save automatically. So far I have to use a btn to save record, but would like it to be done automatically...

Any ideas how I can achieve this?

Kysterathome

 

[KenReay]

Hi

See DoCmd.RunCommand acCmdSaveRecord

but, be aware Access will save the record anyway when you close the form, and/or move off the record

Regards

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

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

UK

 

[TheAceMan1]

How are ya kysterathome . . . . .

Or you could use:

[blue]   Me.Dirty = False[/blue]

See Ya! . . . . . .

 

[kysterathome]

KenReay,

I tried your idea on After Update, On Enter, On Change, but not working, it still only returns an empty result in frmData.

TheAceMan1, my VBA is quite poor still. Where/how do I apply your me.diry=false?

 

[TheAceMan1]

kysterathome . . . . .

Are you attempting to [blue]save the new list in the combobox?[/blue]

See Ya! . . . . . .

 

[kysterathome]

TheAceMan1

Actually, the user has the choice: either he choses a name in the dropdown in frmData, or he uses the frmSearch, which helps the search via a form. The name chosen in frmSearch (chosen among the same names that are in the dropdown list in frmData) will populate the dropdown list in frmData. Now, upon clicking the btnSend, the results of frmData will popluate the fields of another form. However, now, have to press btnSaveRecord prior to clicking btnSend, for the data to be transferred. And it is this btnSaveRecord that I would like to avoid.

Kysterathome

 

[kysterathome]

Ha! Of course, I got it....

Just insert

 DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Before the actual code for the submit button

Kysterathome

 

[KenReay]

Hi

That is just the "old fashioned" version of DoCmd.RunCommand acCmdSaveRecord, which was superceded from Access97 on (I think from memory), anyway, same effect

Regards

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

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

UK