Navigation Button on Field to Scroll the Record.

[cap.zadi]

Hi,

I am using a Main form "Customer Information'' and a subform on it "KeyContacts". I don't want to use Navigation buttons on subform to scroll the records as one customer can have many Key Contacts.



So what could be the best way to handle the sitation;

- A Naviagtion Button on "KeyContactID" Field to scroll the records?
- A combo box to see the list of contacts?

Any suggestions will be appreciated.


thanks.

zee

[June7]

Is the subform in Datasheet or Single view?

[cap.zadi]

It is in single form view.

[cap.zadi]

Please have a look at Form Snap Shot.


One customer can have many Key Contacts, Addresses (Offices/Branches) and associations (this form is in datasheet view so no prb for that).


I tried with one combo box to scroll the Records but it is not working also. but i will prefer a Navigation button on ContactID Field to scroll the records rather than combo box.


please advise.

regards.

[June7]

An unbound combobox to select filter criteria in conjuction with a parameterized query is one method. The parameterized query would be the RecordSource for the KeyContacts subform and the parameter would be reference to the combobox.

Review: http://datapigtechnologies.com/flash...tomfilter.html

If it doesn't already, the combobox RowSource should be restricted to contacts related to the current customer on the main form.

Buttons to scroll Previous/Next would involve more code. Review: https://www.accessforums.net/program...rty-30082.html