filling in a dynamic label based on the selection in a combo box on the same form

[taholmes160]

HI Folks:

Im working on a section of my database where trains are scheduled. Due to the way things work, the trains are "created" in one form, and then scheduled in a different form. the creation form works great. Im trying to stretch my skills a little bit doing this scheduling form.

The train to be scheduled is selected in a combo box, which is powered by a query that contains all the relevant info. (called QryTrains). Id like to have a dynamic label that changes based on the train selected for scheduling. The label should read "Departure from (and then have the name of the station drawn from query trains) and then have a combo box with time values in it -- the combo box is no issue at all, getting the form to read the value from the query and insert it in the label is a bit more of a problem. I suspect it needs a requery someplace, but I'm not sure where.

I'd attach a copy, but for some reason the attachment manager keeps failing when I try to upload

Thanks for the help

TIM

[RuralGuy]

I'd attach a copy, but for some reason the attachment manager keeps failing when I try to upload

Try Compacting and Repairing your db first and then ZIP it up before uploading.

[taholmes160]

@ruralguy -- thanks for the tip, unfortunately, Its still doing the same thing after compacting and repairing

TIM

[CJ_London]

getting the form to read the value from the query and insert it in the label is a bit more of a problem

in vba you would use something like

me.lblcontrolname.caption="Departure From " & me!stationnamefield

where you put this code depends how your app works - but suggest probably either the form load or current event

[RuralGuy]

How large is the file after ZIPPING it up?

[taholmes160]

Hey Rural Guy:

Its 4,993KB, so what 4.9 megs? not real big, is that too large?

[taholmes160]

Ajax:

the form will be able to know were the departure is from once I choose the train in the combo box above, so where would that be?

also, is lblcontrolname a real function, or do i need to supply that name? -- NOT a VB guy (doesnt mean I dont want to learn, but have exactly 0 experience with it)

Thanks so much
TIM

[RuralGuy]

Hey Rural Guy:

Its 4,993KB, so what 4.9 megs? not real big, is that too large?

Unfortunately, 2.0 MB is the limit.
Did you include all of the fields you need in the RowSource of the ComboBox. If so it is easily accessible in the AfterUpdate event of the control.

[CJ_London]

is lblcontrolname a real function

no its the name of your label control

the form will be able to know were the departure is from once I choose the train in the combo box above, so where would that be?

that would be the name of your combobox - from your description it needs to be the first column that is displayed. Typically this will be the second column (the first is usually the PK and is hidden). Columns are numbered from 0 for the first column so your code might be

me.lblcontrolname.caption="Departure From " & me.comboboxname.column(1)

[taholmes160]

RuralGuy:

Yes I did for the train ID combo box, all the values I need are there, Im having trouble getting the ones that I want from there to the label box which is the next line

TIM

[RuralGuy]

The syntax to reference a column in a ComboBox is: Me!THENAMEOFYOURCOMBOBOX.Column(n)
Where n is the column number starting at 1.