Access by default adds new records if you push the small add new record at the bottom or if you add a custom button to add new records.
I don't believe that you need to write anything to add the record. Just click the add new button and type away. Access saves after each field is changed so anything you type in a field will be added to the new record. That said, I think it is being a little over complicated to try to add records based on a value in the combo box. If you want a new record, just click the new record button and add it. Then, the new name will be added to the combo box as soon as you leave the record. Does that make sense or am I babbling? J - Experience hath shewn, that even under the best forms those entrusted with power have, in time, and by slow operations, perverted it into tyranny - Thomas Jefferson on government On Thu, Aug 19, 2010 at 5:13 PM, Bruce Sorge <[email protected]> wrote: > > Yeah, as I looked at the code closer I realized that. I'll make some > changes > and see what happens. > > sent from my HTC EVO > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:325618 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
