[CODE]/Dim db As DAO.Database
Dim rec1 As DAO.Recordset
Dim recFiltered1 As DAO.Recordset
Set db = CurrentDb
Set rec1 = db.OpenRecordset("SELECT [Product Suppliers Name].[Product ID], [Product Suppliers Name].[Supplier] FROM [Product Suppliers Name];", dbOpenDynaset, dbSeeChanges)...
Hi,
One is mainform, the other is a subform.
The row source of the mainform is base on read only query. This query extracts various fields from various tables. And one of the fields is ID.
The row source of the subform is base on a table. The common identifier(“key”) between the read-only...
I have a subform linked to one mainform
The row source of the subform is base on a table.
The row source of the mainform is base on a query(should be read only query) because sum(), group by clause, join are used in the query.
The common identifier between the table and the query is an ID...