Hi there everyone,

I just have a quick (pretty sure it is quick) how to question for Access 2007.

So I made a mistake in designing the Access 2007 databse (still learning) anyway so I need to do a workaround that requires me to make the following situation.

So I have a table named Courses have two feilds CrsID and CrsName. In a form there will be a combo box that EU will select CrsName. I need the CrsID to then update to a separate combo box that will be hidden to help update other combo boxes. I know I need to do a "After Update" Event Procedure on the CrsName combo box but I cannot figure out the VB code to push the CrsID to the other combo box.

If you're wondering the mistake I made, it was a relationship mistake and I am this close to being done and just need the quick fix.

Free Mojito to the sexy one who save my rear.

Is this what you're trying to do?

Autofill

Even if not, it has an example of copying a value.

That worked great. Thanks a ton!

*Hands over Virtual Mojito*

Virtual Mojito?!?! Those aren't as refreshing as real ones!

Happy to help.