G
Guest
I am working with this production form. Due to the people I work with,
clicking buttons is about all they can handle. So my form starts up with
four buttons, one for each production line. They click on one of the buttons
and the form goes to the correct line and they can go to work. The code that
takes them to the correct record is a simple go to command. This allows them
to use the scroll button on the mouse to get to the different lines, even
though I have taken away all navigation buttons from the form. This is bad.
Furthermore, I know that the filter command limits the user to only that
record; however, this causes my subform to leave data entry mode and show all
records. That is even worse because the users then try to simply change the
text boxes. I need to solve this in one of two ways.
1. Either make it so the users can not scroll through records when the go
to record command is used.
2. Force the subform to go to a new record when clicking on a button.
The code I have tried is this
This first line is what I have right now. It allows users to change records
with the mouse scroll button.
DoCmd.GoToRecord acDataForm, "frmResinMixLine", acGoTo, intLineID
These next two are commented because they have a worse side affect of
allowing users to see all records even though the subforms property for data
entry is set to true
'Me.Filter = "[LineID] = " & intLineID
'Me.FilterOn = True
intLineID is just the incoming variable that is passed by value from the
calling procedure. It is the line the user is going to work on.
As always any help would be appreciated.
clicking buttons is about all they can handle. So my form starts up with
four buttons, one for each production line. They click on one of the buttons
and the form goes to the correct line and they can go to work. The code that
takes them to the correct record is a simple go to command. This allows them
to use the scroll button on the mouse to get to the different lines, even
though I have taken away all navigation buttons from the form. This is bad.
Furthermore, I know that the filter command limits the user to only that
record; however, this causes my subform to leave data entry mode and show all
records. That is even worse because the users then try to simply change the
text boxes. I need to solve this in one of two ways.
1. Either make it so the users can not scroll through records when the go
to record command is used.
2. Force the subform to go to a new record when clicking on a button.
The code I have tried is this
This first line is what I have right now. It allows users to change records
with the mouse scroll button.
DoCmd.GoToRecord acDataForm, "frmResinMixLine", acGoTo, intLineID
These next two are commented because they have a worse side affect of
allowing users to see all records even though the subforms property for data
entry is set to true
'Me.Filter = "[LineID] = " & intLineID
'Me.FilterOn = True
intLineID is just the incoming variable that is passed by value from the
calling procedure. It is the line the user is going to work on.
As always any help would be appreciated.