Unbound forms and unlinked tables

[hooks]

Access 2000 ADO

I hava attached a folder with 2 databases in it. CustomerDATA.mdb and Customer.mdb.

CustomerDATA.mdb has 2 table in it. tCustomers and tUsers

tUsers records

UserID -- UserName
1 -- Hooks1
2 -- Jim2
3 -- Bob3
4 -- John4

Customer.mdb has but 1 form.

I want to be able to connect to the CustomerDATA.mdb database and retrieve, add, edit, delete and save records with unbound forms and unlinked tables. I am able to do this but the value in the combo box is wrong. I have a 2nd record set to fill the value of the combo box.

For instance - Say I save Hooks1 in the combobox of the first record and save the record. The table is updated with the correct data but the next time i view the record then Jim2 is displayed in the combo box even though it should say Hooks1. If I save Jim2 in the combobox then Bob3 is displayed the next time I view the record. I always adds 1 to the primary key.

I am trying to do this database properly and proffesionally. I figured completely unbound forms and unlinked tables was the way to go. Please Help



Thanks
Access 2000 ADO

Extract the .zip file to C:\
so that all of the connections strings will work.

 

[WayneRyan]

Hooks,

What is cboUserID?

Don't "drop" into ErrorHandlers by accident (See: GoTo Hell routine).

And, what's wrong with bound forms and Linked tables? In my opinion,
this is way too much code for that app. To get it to run: Make Directory,
Make ADO ref, rewrite combo box population (I don't have .AddItem).

Too much work,
Wayne

 

[hooks]

Yeah the error handlers are messed up. Im not worried about those for now. I can fix those later.

This is just a test application.

Did you see my problem of the combobox displaying the wrong data?

That is what has been bothering me a whole bunch.

Thanks

By the way I fixed the problems you suggested.

 

[WayneRyan]

Hooks,

Other that cboUserID, I don't know.

Wayne

 

[hooks]

Sorry this should be posted in the modules and VBA

 

[hooks]

I got it working.