I would like to open one form from another (edit form from a list form); however, Access does not seem to like it when I am pulling data from more than one table...
I am using a macro to open the form, specifically the "OpenForm" command with the "Where Condition" field. When I use a single table as the data source for the form to be opened, I am able to open the form to a specific record in that table. However, when I add the second table to the query builder, and try to open the form, it opens as though I am creating a new record (blank fields except my primary key field). The two tables do have a relationship with one another through 1 field of each table, so it seems to me the DB should know which record to get from the second table...
Any ideas?
Start Free Trial
