Search results

Is there a way to open another database (in access) by using a macro?

Is there a way to open another database (in access) by using a macro?

Yes, the use of a subform would help you with this. First of all, you need to have a way to link the form and subform. If you use the Form wizard, you can maybe do this, but you need to have the right relationships established and the table your subform is based on needs to have a primary key...

This is what a form does. If you set the recordsource for the form to the table you want to use, the data will be available for display and data manipulation.

I have two tables that I want to display info on one form. It would be awesome if I could select data from a combo box (from table 2) that would automatically fill in the rest of the fields' info from table 2. If I select someone's name, I want the remainder of their address fields to be...