Hi everyone and thanks in advance for any help,
I'm having a shot at my first database with Access 2013. My intention is to create a (fingers crossed) very simple vehicle registry using the asset template provided by Access. The database needs only to provide a simple search function to call up details on vehicles quickly.
I've added some of my own fields to the table in the asset template such as registration numbers etc. In the 'Asset List' form the template has an already existing search text box. However I can't work out how to correctly edit the search function properties so that it displays any data included in my new fields.
Records are displayed and work fine when using the search text box for pre-existing fields in the template. I'm assuming I may need to create a new macro for the search text box or change the control source however I'm unsure if there is a faster way to include these new fields than to create a new macro etc.
Many thanks for any tips,
cjmcneil
I'm having a shot at my first database with Access 2013. My intention is to create a (fingers crossed) very simple vehicle registry using the asset template provided by Access. The database needs only to provide a simple search function to call up details on vehicles quickly.
I've added some of my own fields to the table in the asset template such as registration numbers etc. In the 'Asset List' form the template has an already existing search text box. However I can't work out how to correctly edit the search function properties so that it displays any data included in my new fields.
Records are displayed and work fine when using the search text box for pre-existing fields in the template. I'm assuming I may need to create a new macro for the search text box or change the control source however I'm unsure if there is a faster way to include these new fields than to create a new macro etc.
Many thanks for any tips,
cjmcneil