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.