473,320 Members | 2,073 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Tapping into 2nd unbound Combo colum

Acc97
on a subform I have a series of Combo box's which because of my
inability to think ahead! I have had to use a field on the last one
which I did not intend to use, and bound to it. Therefore, I have a
two column drop down with the first field showing a Ref No. but the
second column showing me what I really want but I can't tap into it "
So near yet so far"

What I want to do is see on the form the second column in a separate
text box but how I extrapolate this just eludes me!!

Within the SQL I see the field I want but I just can't seem to get to
it! using a text box.

I have tried to use DLookup but this has proven to be easier said than
done!! and I still have not sussed it out on how to do it using three
items..

Appreciate any help...

Thanks..
Nov 12 '05 #1
1 1500
You can refer to the other columns in a combo box as
Me.cboMyCombo.Column(n), where n is the column number (starting with column
0)

In the AfterUpdate event of your combo box, put something like:

Me.txtMyTextField = Me.cboMyCombo.Column(1)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Alex" <ge****@yas1.freeserve.co.uk> wrote in message
news:b7**************************@posting.google.c om...
Acc97
on a subform I have a series of Combo box's which because of my
inability to think ahead! I have had to use a field on the last one
which I did not intend to use, and bound to it. Therefore, I have a
two column drop down with the first field showing a Ref No. but the
second column showing me what I really want but I can't tap into it "
So near yet so far"

What I want to do is see on the form the second column in a separate
text box but how I extrapolate this just eludes me!!

Within the SQL I see the field I want but I just can't seem to get to
it! using a text box.

I have tried to use DLookup but this has proven to be easier said than
done!! and I still have not sussed it out on how to do it using three
items..

Appreciate any help...

Thanks..

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Megan | last post by:
I'm using an unbound combo box on a form as a record selector. I'm using the combo box to choose certain types of music, i.e. Alternative, Pop, Rock, etc…and then run a report based on the...
2
by: J. Yuan | last post by:
Hi, I am having some problems getting combo boxes to work right. I'm trying to get a combo box to select all the distinct "invoice numbers" in a table by using the following SQL statement:...
2
by: Todd | last post by:
Hello, I'm curious if anyone knows of a way (if one exists) to tell a form (in Access 2002 VBA) to sort on an unbound column of a combo box on the form. Here's what I want to do: A combo box...
2
by: Todd | last post by:
Hi. I want to sort the records on my form (using either a continuous form or a datasheet) by the unbound "description" column in a combo box on the form (or in the datasheet.) Here's a rough...
2
by: Wolfgang Kreuzer | last post by:
Hello all, I am converting an Axs 2.0 application to a2k (I know A2K is not the most current version but Axs 2.0 support ended and A2K is supported in our company amd on every PC). The form is...
2
by: Susan Bricker | last post by:
Greetings! Still the same application (as previous posts). I worked on the app while at work (don't tell my boss ... cause this is just for fun and not work related) and the form was working,...
3
by: Stig | last post by:
Hi, Any help on this one will be greatly appreciated as I have spent too long banging my head against the screen trying to get it sorted. Basically I would like to have a select all records...
8
by: Robert | last post by:
I have a form (Worksheet) that works fine by itself. I have now created a seperate form (MainForm) that has a command button in the header and an unbound subform (FormFrame) in the Detail section....
9
by: prakashwadhwani | last post by:
I have an unbound combo box in the form header. I have used an input mask "CCCC" 40 times to limit the max number of characters to 40. When I tab into the combo box & press a character say "K"...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.