Re: Need Combo Box Help!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Scott (tvallery_at_columbus.rr.com)
Date: 05/15/04 

Date: Sat, 15 May 2004 14:39:44 GMT

Hi Reddy!

  Hey, thanks for the help, however, I think I'm still missing something. Maybe you're assuming something I should know and don't.

One person suggested typing the following in my text box Control Source: =ComboBoxName.Column(1)
Is that right? I want a value displayed in a particular text field on my form to be based upon my selection in my in the combo box I created.

I want my combo box to display one particular field...... For Instance, in my case, my combo box displays 1 column that lists book titles. Based upon the choice I make in that list of book titles I want the Author(s) of that book to appear in another text box on the same form, as well as its location in another and etc. Much like selecting a Clients name and their address, city, state, etc appear in their relative locations.

  You sent me some good information which I've kept, however, I'm not sure where or how to apply that information, or if it is going to do what I need. It looks as if your command line will only list those within the same combo box and not in separate locations on the form.

  I'm trying to use the Access Help, but I must not be punching in the righ information or question.

  Thanks for your patience and help!

  Scott
  "Reddy" <anonymous@discussions.microsoft.com> wrote in message news:45FD24EC-311B-40BE-A79C-31E662CF94D2@microsoft.com...
  Hi Scot,
  Here is the example :
  1 Combo1.Rowsource = "Select Last_Name,First_Name,Phone_No,Fax_No >From Employees"
    or what ever the fields you want from the table or just give the table name, you will get the field values as is in the table.

  2 Set the column count of the combo box property to 4 or how many columns you want.

  3 Set the column width property to 1;1;1;1 the higher the number, the width of each column will increase.

  You are done :)

Relevant Pages

  • wtb atari SPRINT 8 eight player driving game,1970s
    ... hey guys, ... im looking to buy one of these huge machines that was made in the mid ... to late 70s, working or not, complete or missing some parts, basically ... monitor is in the middle and it had an overhead canopy ...
    (rec.games.video.arcade.collecting)
  • Re: Why do so many commentators say Jerr-denn Hair?
    ... Hey, Antonio Veranos... ... :> Am I missing something, or are these people getting it wrong? ... most people around my neck of the woods growing up ...
    (rec.sport.football.college)
  • Re: Open/Close: Missing a Close..Somewhere :)
    ... i am missing a matching close... ... Not me, but you could do as I do - I indent at every Open statement, so ... auric underscore underscore at hotmail dot com ... Hey, ninja crack whore! ...
    (comp.lang.basic.visual.misc)
  • Re: [PHP] Please hack my app
    ... Hey there, ... What you are asking for is pretty unfair, unless I am missing something? ... If on the other hand you have identified the part that troubling you, or getting unexpected results from a code segment... ...
    (php.general)
  • Re: I have been CHALLENGED. . .
    ... hardback. ... Hey, I'm missing a few books in that series... ...
    (alt.sysadmin.recovery)