Synchronize navigation buttons and get them to work

[Guest]

I have a form on which are a set of unbound controls (mix of text and combo
boxes).

The controls are unbound because the form is set up for a batch update; i.e.
user can enter data and once the form is filled in, the user must click an
update button which then uses ADO to update the tables; user may also cancel
and lose anything entered. Also, two combos are being used to allow the user
to go immediately to a particular record. This all works great.

However, because everything is unbound, the navigation buttons do not
function. I need a way to allow the user to scroll through the records
already entered on this form; how can I do this?

I either need a way to make the navigation buttons work or build my own
(which is okay too). Can someone please post exampe VBA or walk me thru
hooking up the built-in navigation buttons? Thanks much in advance.

 

[Guest]

You can't do it with the built in navigation buttons. You will have to
create your own. Use the Click event of each button to fetch the record and
fill the form controls.

 

[Jamie Collins]

You can't do it with the built in navigation buttons. You will have to
create your own.

What about using the ADO Data Control (ADODC)?

Jamie.

--

 

[Guest]

If you are not, as I am, adverse to ActiveX controls, that would be okay;
however, the question has to do with navigation buttons.

 

[Jamie Collins]

If you are not, as I am, adverse to ActiveX controls, that would be okay;
however, the question has to do with navigation buttons.

Isn't that what the ADODC is i.e. graphical navigational buttons for
ADO Recordset methods MoveFirst/Previous/Next/Last? See figure 17 on
this page:

http://www.microsoft.com/msj/0299/ado20/ado20.aspx

Apologies in advance if I've got the wrong thing entirely.

Jamie.

--

 

[Guest]

Thanks for the info, Jamie. I will study it. I was not aware of that
control because I don't usually use ADO. As I said earlier, I try to avoid
ActiveX controls where possible. My personal experience with them has not
been all that positive.