Stop people selecting other records when in a form

[StevenSkinner]

Hello

Hope someone can help.

I have created a database and have a form where people can find a record. but once they have found the record they are looking for, I do not want them to be able to select another account - but still be able to enter and change details on selected record.

I have already removed the record Selectors, but if the user use's his mouse scoll button, it scrolls through the records !!!

What can I do to stop it doing this ????

Please Help

 

[Norie]

Steve

What I normally do is create a (continuous) form that lists something like the Account number and a few other details.

On the form is a button that opens up a single record form based on the accoun ID containing the full details of that account.

This form has Record Selectors and Navigation Buttons switched off.

It also has a button to return to the form listing the accounts.

 

[StevenSkinner]

I have tried the above and this still allows user to scroll throgh the records using the mouse scroll button !!

Any Idaes ???

 

[Norie]

Steve

I've just opened a database I designed in Access 97.

It had forms as described in my post and when I went to the 'full details' form the mouse wheel had no effect.

What code did you use to open the second form?

This is what I used.

Private Sub btnOpenDetails_Click()
On Error GoTo Err_btnOpenDetails_Click
    Dim Curr As Long
    Dim stDocName As String
    Dim stLinkCriteria As String
    
    Curr = Me.ContractorID
    
    stDocName = "Insurance Details"
    
    stLinkCriteria = "[ContractorID]=" & Curr
    
    If IsLoaded(Me.Name) Then DoCmd.Close acForm, Me.Name
    
    DoCmd.Close acForm, "Contractors Summary"
    
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    
Exit_btnOpenDetails_Click:
    Exit Sub

Err_btnOpenDetails_Click:
    MsgBox Err.Description, vbInformation, "Error message"
    Resume Exit_btnOpenDetails_Click
    
End Sub

It's a contract insurance database, the Contractors Summary is a continuous form listing the contractors (and some other data).

When the btnOpenDetails button is pressed the form insurance details is opened based on the ContractorID from the Contractors Summary.

 

[StevenSkinner]

I have a "Single Form" Which finds the Record I'm Looking For, and displays the record in the "Single Form" which has no record selector. but skips through the records when I use the mouse scroll button ???

Any Ideas how I can lock the form from doing this ???

 

[Norie]

Steve

That isn't what I suggested.

See my edited post.