How do I create emerging boxes in a form depending on the selection on another box.

[nikapo]

Hello,

I want to create a form in witch, whenever I select a status, will emerge a secondary cell or cells,
depending the first choice, where I could edit certain other values.

Specifically, in the first cell I will be referring whether the cell will have a specific value (A or B).
When A is selected two different boxes must be opened exactly under the first box. If B is selected
then just one box is needed.



I also want to mention that on the table must appear as one.
Think of it as an ms excel form where next to values A or B a C value appears with two cells under it
or a merged cell with a single value.

My first thought was to set, on the B value case, the second secondary cell inactive but this is also
difficult for me.

Thank you.

[ranman256]

user chooses option in a combo box A or B

sub  cboBox_afterupdate()
   txtBox1.visible = true
   txtBox2.visible= cboBox = "B" 
end sub

[ItsMe]

@ nikapo,

Access is not like Excel. You need to store your data in tables. These tables need to have specific columns/fields defined as Key fields. Your tables will have relationships based on certain Key fields. Tables in Access are not "flat" like and Excel spreadsheet.