PC Review


Reply
Thread Tools Rate Thread

Combo Box with Text Box?

 
 
Alison via AccessMonster.com
Guest
Posts: n/a
 
      24th Jan 2007
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drag and drop text in userform text / combo boxes Roger on Excel Microsoft Excel Programming 1 22nd Nov 2009 11:34 AM
Cascading Combo Box - filling a text box instead of a Combo box =?Utf-8?B?U2N1ZGE=?= Microsoft Access Forms 5 25th Jun 2007 06:46 PM
Select text in combo box text area on click? Robin Microsoft Access VBA Modules 4 9th Jul 2006 01:50 PM
connected combo boxes (text in the second combo dissapears) =?Utf-8?B?dmFoaWQ=?= Microsoft Access Forms 0 15th Jun 2005 01:07 PM
how do i link a combo box to another combo box or list or text bo. =?Utf-8?B?Y2hyaXM=?= Microsoft Access Forms 1 18th Feb 2005 12:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:51 PM.