Adding & Editing Data

I need to be able to add & edit data in an Access database using VB5.  Is there a "neat" way to do it.  I've found using bound controls is a little messy, though if anyone know a wa around it.
I've tried just using the recordset addnew and edit routines straight out of dataform wizard, but when other people use the program, it's gets a little messy if they hit the wrong button (the error "Tghis action was cancelled by another.....").
Any help would be appreciated.
 
nu2vbAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DalinConnect With a Mentor Commented:
nu2vb,
The "neat" or "messy" is not due to the use of bounded controls. It is in how you program it.

When the user click "addnew" or "Edit", you can disable buttons other than "Cancel" or "Update", and only the user click on one of these, you can enable the other buttons in addition to the cancel or updating action.

Regards
Dalin
0
 
nu2vbAuthor Commented:
That sounds like a fair call.  I will try what you have suggested.  Looking back at it, it's quite simple yet I didn't even think of it!
Thanks for your help!

0
All Courses

From novice to tech pro — start learning today.