By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 2,185 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

Goto next record w/filter (Repost)

P: n/a
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

Sep 15 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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)
Sep 15 '07 #2

P: n/a
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

Sep 17 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.