Yes I am very much an amateur with access and have no experience with coding 
. I am trying to find out in simple terms (for a simple mind
) how I can do the following:
In table i have a field (data type yes/no) named "pcb". In main form I have the same field - How do I have a sub form named "SFrm_pcb) displayed when user chooses answer yes to the field PCB? If I can conquer this I can continue but so far have been hitting my head against a wall and have no coding background.
Ideally I also need to set up table with up to five material categories (in table field name material_category lookup to table material_category) and just as in previous paragraph if pcb is selected need to have sub form SFrm_pcb displayed within the main form.
I have posted a similar type of question before but don’t think I am explaining myself properly. I have attached the database if anyone wants to take a shot. (user name admin with psswd AQSkk4). Appreciate all past help and your patience to all forum readers.
. I am trying to find out in simple terms (for a simple mind
In table i have a field (data type yes/no) named "pcb". In main form I have the same field - How do I have a sub form named "SFrm_pcb) displayed when user chooses answer yes to the field PCB? If I can conquer this I can continue but so far have been hitting my head against a wall and have no coding background.
Ideally I also need to set up table with up to five material categories (in table field name material_category lookup to table material_category) and just as in previous paragraph if pcb is selected need to have sub form SFrm_pcb displayed within the main form.
I have posted a similar type of question before but don’t think I am explaining myself properly. I have attached the database if anyone wants to take a shot. (user name admin with psswd AQSkk4). Appreciate all past help and your patience to all forum readers.
Last edited:
