Goto next record w/filter (Repost)

[bhipwell via AccessMonster.com]

I need to put a button that allows the user to move to the next record. On
the form, I have a list of employees that are filtered by the company they
work for.

Obviously, if I use the simple Gotorecord command, it will pull up the next
record regardless of what company that employee works for. So...

1) I need the button to take the user to the next record where the company
(field is CompanyID) matches the company on the form.

2) I need the list box that displays the employees specific to the company,
to highlight/select the employee to which the next record function takes them.
Thanks in advance!

B

(reposted after no reply)

--
Message posted via http://www.accessmonster.com

[Salad]

bhipwell via AccessMonster.com wrote:

I need to put a button that allows the user to move to the next record. On
the form, I have a list of employees that are filtered by the company they
work for.

Obviously, if I use the simple Gotorecord command, it will pull up the next
record regardless of what company that employee works for. So...

1) I need the button to take the user to the next record where the company
(field is CompanyID) matches the company on the form.

2) I need the list box that displays the employees specific to the company,
to highlight/select the employee to which the next record function takes them.
Thanks in advance!

How are your presenting your data? As a main form (company) with
subform (employees at that company)? How can you have a filter for
employees at one company and have it move to some other company? It the
GoToRecord executing for the company or for the employee?

>
B

(reposted after no reply)

[bhipwell via AccessMonster.com]

Salad,

I figured it out through a similar post. I had a list box that on its own
was filtering out only those employees that matched the company choosen on a
previous form. All I did was set the filter on open to the Company ID.
Thanks!

B

--
Message posted via http://www.accessmonster.com