First of all I would like to say Hi to everyone!
I am designing a database front end in access at the moment and I am rather stuck on something as I am not very experienced with access forms.
The general layout of the form is this:
*----------------------------------------*
|Manufacturer (Combo box)| |Boilers/Showers (option group)| |Active/withdrawn (option group)|
----------------------------------------
>>Subform returning data from query using settings chosen above
*------------------------------------------*
I have linked the Manufacturer and Boilers/Showers fields as master/child links and that works fine with the subform. The problem is the Active/Withdrawn option group. The way the information is stored in the database is if the product has been withdrawn there is a date in the withdrawnDate field of the table. If the product is active, there is no date.
So I need to do a "Where withdrawnDate is Null" type query, but I do not know how do do this and apply it to the subform along with the settings above.
And ideas? Any help is MUCH appreciated!!
Thanks!
-Shiv
I am designing a database front end in access at the moment and I am rather stuck on something as I am not very experienced with access forms.
The general layout of the form is this:
*----------------------------------------*
|Manufacturer (Combo box)| |Boilers/Showers (option group)| |Active/withdrawn (option group)|
----------------------------------------
>>Subform returning data from query using settings chosen above
*------------------------------------------*
I have linked the Manufacturer and Boilers/Showers fields as master/child links and that works fine with the subform. The problem is the Active/Withdrawn option group. The way the information is stored in the database is if the product has been withdrawn there is a date in the withdrawnDate field of the table. If the product is active, there is no date.
So I need to do a "Where withdrawnDate is Null" type query, but I do not know how do do this and apply it to the subform along with the settings above.
And ideas? Any help is MUCH appreciated!!
Thanks!
-Shiv
