T
Tony Williams
I have a form that I originally built on a query which had two linked
tables. I've now realised that all the controls on my form are actually in
one table so I deleted the other table from the query. However now my form
only shows the first record. There are controls on the form that reference
the other table in DLookup expressions but I didn't think the table had to
be part of the query for them to work. if I put the table back in the query
and include all the fields using the * it works. However if I take the ID,
which is the primary key field, out of the query of the second table and add
the fields from the second table individually, it doesn't. Anyone any ideas?
Thanks
tables. I've now realised that all the controls on my form are actually in
one table so I deleted the other table from the query. However now my form
only shows the first record. There are controls on the form that reference
the other table in DLookup expressions but I didn't think the table had to
be part of the query for them to work. if I put the table back in the query
and include all the fields using the * it works. However if I take the ID,
which is the primary key field, out of the query of the second table and add
the fields from the second table individually, it doesn't. Anyone any ideas?
Thanks