I am working on a simple form to record the journeys made by a group of
couriers.
About half of the journeys are from regular customers and go to and from the
same addresses; other journeys are 'one-offs' and will never be repeated.
What I have been searching for is a neat way to pull the 'regular' addresses
down from a table and also store the records of the 'one-off' addresses.
I appreciate that I cannot have a combo box containing the regular addresses
that will also let me enter the one-off addresses (I tried that and got
#error in all the combo box fields)
I have been searching through the postings here and have learnt that I can
add a combo box from which the user can select 'Regular' and I can then make
a second combo box which will only show the records from the 'regular
addresses' table. What I think I need is for that second combo box to turn
into a text field if the user selects 'One-Off' from the first combo box . . .
but I don't know if that can be done.
I could just have two fields for the collection address and two fields for
the delivery address; one each for the regular address (as a combo box) and
one each for the one-off addresses (as a text field) but I have a bad feeling
that this may present even bigger problems when I start building reports.
Am I trying to be too clever? Any guidance or assistance would be much
appreciated.
Thanks
Alison
--
Message posted via
http://www.accessmonster.com