can one user update a record while another user views the it

[miscluce]

can one user update a record while another user views it? I am using SQL server as my database. This is my first time deisgning an application with access/VBA and I am trying to find the easiest way.

Do I have to have everything unbound or can I bound some stuff such as, text boxes, combo boxes, etc. ?

Or can I do this withoout vba coding? Need some advice?

 

[2Grandpa]

can one user update a record while another user views it? I am using SQL server as my database. This is my first time deisgning an application with access/VBA and I am trying to find the easiest way.
Depends on the record locking you set up.

Do I have to have everything unbound or can I bound some stuff such as, text boxes, combo boxes, etc. ?
With Access these can be bound or unbound as you wish with the property setting of each item. You do not need to use vba coding. Macros or vba coding are used for events such as open, change, close, etc.

 

[miscluce]

thanks for the reply.

"Depends on the record locking you set up" what you mean?

"You do not need to use vba coding. Macros or vba coding are used for events such as open, change, close, etc"
OK, but what are my limitations if I dont use any vba code and use macros instead?