Search results

See if this helps you understand > http://msdn.microsoft.com/en-us/library/bb404901.aspx It's for 2007 however the principle is the same. You can add a button on your form to update the table with your selection.

Another thing of note, you are turning off warnings in your subs but are not turning them back on.

Set your rowsource of the combo box to query all the information you want to update. Set Column Widths and Column Count appropriately. For the combo box you will only want to store the ID for the name and have the Name of the person in the second column to show so that when someone choose a name...

When you say it's not working, what's not working? Explain more about your set up. Do you want a new form with just the company filled in?

basically splitting is just placing all tables in a "backend" database and linking them to the "frontend" database. There is a wizard to split the database for you. You should always make a copy of your database and work with the copy to split the database. That way if anything does go wrong you...

Here is instructions from Jon Watson at Biomationsystems.com that will work for what you are wanting to do. Change as needed, give Jon credit. MS Access Tip – How to use variables in the Access query design form. In this example you are going to learn how to enter or select data in one form...