G
gordon
Having been out of the programming arena for a long time
i am developing an Acess Database which uses
forms/subform. I am having difficulty with the following;
How to populate a field (description) on the subform from
a 'Product' table using the field value in the previous
field on the form (product code) which is the key of the
Product table.
Where can I use SQL within the database - expresions ?,
code builder ? or elsewhere. Also any exapmles would be
appreciated using SQL to populate controls.
Syntax of using DLOOKUP to populate a control.
And finally, any reference sites which I can check out
and see examples of the above types of issues. I may be
alone in this but it seems difficulat to find details of
how to perform the basic tasks in Access 2003.
Any help appreciated
Gordon
i am developing an Acess Database which uses
forms/subform. I am having difficulty with the following;
How to populate a field (description) on the subform from
a 'Product' table using the field value in the previous
field on the form (product code) which is the key of the
Product table.
Where can I use SQL within the database - expresions ?,
code builder ? or elsewhere. Also any exapmles would be
appreciated using SQL to populate controls.
Syntax of using DLOOKUP to populate a control.
And finally, any reference sites which I can check out
and see examples of the above types of issues. I may be
alone in this but it seems difficulat to find details of
how to perform the basic tasks in Access 2003.
Any help appreciated
Gordon