Help with multiuser forms please

[caman]

I am currently using access in a multi user enviroment, the problem I am having is that you only get a warning that someone else is in the form when you gp to save it.
What I would like is some code that does the following,
if form open, then goto next form.
The biggest problem is that I am new to the vb side of things, so if any one can help me some directions on how to make it work as well would be great.

Thanks for any help in advance

caman

 

[Fornatian]

This may be a syntax misunderstanding but from what you have asked, you need to understand that it is not the form that is locked but the underlying record which is presented in the form, therefore opening a different form with the same information will not solve your problem as the same record will be presented and will still be locked.

The question I am bouncing back is, if form1's records are locked is form2's record the same or related to a different record or set of records?

 

[caman]

Ok I get your point

yes you are correct, it is the record not the form that I need to have locked.

can you help?

 

[cogent1]

Records are locked so that two users can't edit the same record at the same time. If you and another user have a form open at the same time and the other user accesses a record and changes it, the record is locked only until the change is saved, i.e. very briefly. If you now access the same record, you will be warned that the record was changed while you had the form open and you will be overwriting that change.

I think you are talking about an issue, not of records being locked, but of receiving this warning. Is that right?