I have a form that is huge, but that needs to remain on a single page, i.e. the management don't want to have to scroll down or across for more information. They don't want the form splitting up, or information moving to other forms because, well, they just don't (don't ask, they're simply stuck in their ways and are all technophobes. If they could get away with using a pad and pencil for everything they would).
I'd like to give myself a bit of breathing space on the form and was wondering if the following is possible.
I know that I can create a combo box with a list of field names in it, but can I link this to a text box so that anything that is written or displayed within it relates to the field displayed in the combo box? So, if I chose Meeting Date from the field list the text box would display the meeting date, or would remain blank for me to type the date into, and if I then chose Shipping Number from the field list the Meeting Date would disappear and the Shipping Number would appear.
Did that make sense? If it did, is it possible?
I know that you can link boxes to display information dependent on an entry in a certain box, e.g. Choosing a clients name would bring up a telephone number and address in the relevant boxes, but can it be done with a field list?
Thanks