Form opening and record locking

[mackyrm]

Hi,

I am opening a form, from another form, that is based on a table of 20000 records.

I am using the WHERE criteria to do this, code is included below. I need to provide database access to several users on a network (and only want to lock the record that the user has searched for), and was wondering if this mode of data access will lload and or lock all 20 000 records on the users sytem, or if it will just load and lock the specific record that has been opened using the WHERE condition to open the form...

Advice appreciated.

Regards

Mack

--------
CODE
--------
stDocName = "frmCONTACT"
stLinkCriteria = "[contactID]=" & Me![ContactID]

DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria


End Sub

 

[RuralGuy]

It really depends on how you have the RecordLocks property set on the frmCONTACT form. The property is on the Data tab of the property sheet. The WhereCondition argument just applies a filter to the next form.

 

[mackyrm]

Thanks for the reply RG.

Right, so the form filter is only accessing one record from the tables, locking depenndant upon setting the correct proprty, and leaving the remaining records in the tables unlocked for other users who may need to access and edit them?

Appreciated.

 

[RuralGuy]

How do you have the RecordLocks property set on the frmCONTACT form?

 

[mackyrm]

Edited Records.

 

[RuralGuy]

The form should work as you desire. Lots of success with the rest of your project.