Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Scrolling through records 1
- Thread starter gnt
- Start date
-
1
- #2
In the Query or Recordset bound to your Form you could set the Criteria of the RecordNumber Field to equal the lookup text box on your Form:
[Forms]![YourFormName]![lookup text box].
In the After Update Event of the lookup text box use:
Me.Requery 'Update the Main Form
Me!YourSubForm.Requery 'Update Sub Form (If any)
Using something similar to the above doesn't actually disable the mouse's scroll capability, but displays just 1 record at a time so that there are no other records for the mouse to scroll through.
You might also want to set a Default Value for your lookup text box so that when the Form is first opened it is not blank.
Good Luck
[Forms]![YourFormName]![lookup text box].
In the After Update Event of the lookup text box use:
Me.Requery 'Update the Main Form
Me!YourSubForm.Requery 'Update Sub Form (If any)
Using something similar to the above doesn't actually disable the mouse's scroll capability, but displays just 1 record at a time so that there are no other records for the mouse to scroll through.
You might also want to set a Default Value for your lookup text box so that when the Form is first opened it is not blank.
Good Luck
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question