A select statement based on a table.  

SELECT [Patient].[Pat_ID], [Patient].[med_rec_num],
[last_name] & ", " & [first_name] AS Expr1 FROM Patient
ORDER BY [Patient].[med_rec_num], [last_name] & ", " &
[first_name];

It makes no sense to me.  When the user selects a record
in the drop down box with the above statement, she then
pushes a button to show the entire patient record.  I open
the patient form with the pat_id from the above select
statement.  Then when the user tries to change something
on that form, it locks up.

When I look at the locks section in the SQL server it is
showing that the above statement is locking that record
and the user on both statements (the above statement and
the one for the actual form itself) is the same.  

The one user is locking the record when they choose it in
the drop down box and when they go to the full screen.

This only happens when there are multiple people in the
database although the same user is locking the record.

It has something to do with multiple users but I can't
figure out why since the same user is the one locking the
record.

Anyway, I have something in place that fixed it but it is
pretty ugly and I would like to figure out a better way to
resolve it.  

The drop down box doesn't really do anything but allow
them to select a record so I can open the form with only
that record available.  Is there a way to make a select
statement in a drop down box readonly?

I am guessing but that seems like it would fix my problem
but not sure.  

Thanks for any help.

przeczytaæ: