Hi there
My question is this ....
I have a application which has multiple checkboxs which depending on the selection could or could not have data selected and entered into an underlying table....
My question is can i make the text and the borders invisible using VBA code if the underlying table name that maps to the combobox showing on the form ??? is empty
I show the results of the table in a report
My Form has combo boxes and the user selects the relevant item from the drop down list. Then there is a save fuction to write the contents of those boxes to a table. Then i have another function which i want to check and if there is data in the underlying table then to make the border style solid and toprint the contents of the field within the table if there are any ... of course if there is nothing in the relevant field in the table then i dont want either the borders or the text to show !!!!!!
is this possible as i am going mad trying to figure it out !!!!
Also is there a way to pass to the function the name of the combobox and also the contents as well
i currently use
=checkname(combobox1) for example and this i intend to put on the controlsource of each textbox on the report which displays the relevant table details
This sends tractext THIS is the default value entered into combobox1 .....
Hope this helps explain my problem
Your help is gratefully received
Murray
My question is this ....
I have a application which has multiple checkboxs which depending on the selection could or could not have data selected and entered into an underlying table....
My question is can i make the text and the borders invisible using VBA code if the underlying table name that maps to the combobox showing on the form ??? is empty
I show the results of the table in a report
My Form has combo boxes and the user selects the relevant item from the drop down list. Then there is a save fuction to write the contents of those boxes to a table. Then i have another function which i want to check and if there is data in the underlying table then to make the border style solid and toprint the contents of the field within the table if there are any ... of course if there is nothing in the relevant field in the table then i dont want either the borders or the text to show !!!!!!
is this possible as i am going mad trying to figure it out !!!!
Also is there a way to pass to the function the name of the combobox and also the contents as well
i currently use
=checkname(combobox1) for example and this i intend to put on the controlsource of each textbox on the report which displays the relevant table details
This sends tractext THIS is the default value entered into combobox1 .....
Hope this helps explain my problem
Your help is gratefully received
Murray
