Assign a Default Value in Access and Load in UserForm

[smartrider]

Hello,

I am a UserForm in which there are following fields :

Name
Phone
Fax
Email
and Cmd buttons - ok, Cancel ,Add, Edit and Delete.

The data is in Access link via DAO.
When you click on Edit - another userform pops up where you can make changes to the data. There is a Default cmd button there also.

Is there way that when we click on that cmdbutton the it will chk the checkbox in Access (Default Field) and clears out if there is any other record check.

When we load the userform again that default record should load first.

Please help - I will appreciate it.

Thanks .

 

[vbkris]

can u be a bit more clear (with examples)

Known is handfull, Unknown is worldfull