Bookmark problem

[boblarson]

Okay, I used the add combo box wizard to get the code to work right and I went into the combo's rowsource to limit by the Log#.

I left the old combo and put the new combo next to it so you can see how to use it.

 

[poporacer]

I see your fixes, but when you select a CDC # it doesnot populate the box on the Left side of the form.

 

[boblarson]

Here's a revised file. Instead of using the recordset object to go through things, use the combo box to do the work.

 

[poporacer]

new error

I recieved an error when trying to run the program. Here it is:
Your Microsoft Access Database or project contains a missing or broken reference to the file "msadomd.dll" Version 6.0. I am attempting to find a fix online, I am a little leary of installing things from unknown sites but I am working on it...if you have any suggestions, let me know!

PS. Thanks a million for your help

 

[boblarson]

I recieved an error when trying to run the program. Here it is:
Your Microsoft Access Database or project contains a missing or broken reference to the file "msadomd.dll" Version 6.0. I am attempting to find a fix online, I am a little leary of installing things from unknown sites but I am working on it...if you have any suggestions, let me know!

PS. Thanks a million for your help

Just go to the VBA Code Window and go to TOOLS > REFERENCES and see if one is listed as MISSING. If so, uncheck the box next to it, close the dialog and then close the database and reopen it. It SHOULD fix it for you.

 

[poporacer]

Excellent

Bob,
That seemed to do the trick! Now on to the forms to add new information....I hope I am able to get this running on my own....if not, I will be back. You were a great help!

Thanks a million

 

[boblarson]

Bob,
That seemed to do the trick! Now on to the forms to add new information....I hope I am able to get this running on my own....if not, I will be back. You were a great help!

Thanks a million

Happy to hear you're back on track. Good luck with the rest of the project!

 

[RuralGuy]

Popo,
Just an FYI. If you can find a way for one of the fields in your related tables relationship to be a unique and/or primary indexed field then Access can determine what kind of relationship you have and enforce Referential Integrity for you.