showing results from combo box in form

[Guest]

I have put in a ComboBox to select the meet. The ComboBox has 4 fields - 1)
MeetID, 2) Date, 3) HomeTeam and 4) VisitingTeam. This works nicely to show
the meets and for me to select the appropriate meet.

But when I select meet #1 which was 5 May 2005 with Snider hosting Wayne, I
only get to see the 1. How can I establish other 'textboxes' to continue to
show the date, HomeTeam and VisitingTeam.

The ComboBox looks at the table MEETS.

Thank you for your help.

 

[John Vinson]

I have put in a ComboBox to select the meet. The ComboBox has 4 fields - 1)
MeetID, 2) Date, 3) HomeTeam and 4) VisitingTeam. This works nicely to show
the meets and for me to select the appropriate meet.

But when I select meet #1 which was 5 May 2005 with Snider hosting Wayne, I
only get to see the 1. How can I establish other 'textboxes' to continue to
show the date, HomeTeam and VisitingTeam.

First off, change the ColumnWidths property of the combo box to
something like 0;.5;1;1 to conceal the MeetID (I presume that's not
meaningful to anyone). Now the combo will display just the date when
it's not dropped down.

Then put two textboxes on the form with control source

=comboboxname.Column(2)

and

=comboboxname.Column(3)

using the name of your combo box of course. The Column property is
zero based so these two textboxes will show the home and visiting team
names.

John W. Vinson[MVP]

 

[Guest]

Your comment about not seing the meetID is valid, BUT is there a way of
seeing the Date and the HomeTeam and the VisitingTeam after the meet is
selected (not just one field, but all 3)

 

[John Vinson]

Your comment about not seing the meetID is valid, BUT is there a way of
seeing the Date and the HomeTeam and the VisitingTeam after the meet is
selected (not just one field, but all 3)

Certainly. Use three textboxes, not just two. The third would have
Column(1).


John W. Vinson[MVP]

 

[Guest]

Certainly. Use three textboxes, not just two. The third would have
Column(1).


John W. Vinson[MVP]

 

[Guest]

Sorry about the blank posting. Your idea seems to work fine. I just wanted
to check about the best properties at this point.?
Locked I put as YES
Tab Stop as NO
and Tab Index as 0
Is that smart?

 

[G. Vaught]

Yes that is okay, although the tab index is moot, since you set tab stop to
know and locked to yes.

 

[John Vinson]

Sorry about the blank posting. Your idea seems to work fine. I just wanted
to check about the best properties at this point.?
Locked I put as YES

That's no harm, but irrelevant - as a field with an expression as its
Control Source, it can't be updated anyway.

Tab Stop as NO

Good idea.

and Tab Index as 0

If it's not a TabStop the index is ignored - again, no harm done but
irrelevant.


John W. Vinson[MVP]