Selecting one piece of data automatically selects others

[markswan20]

I have created a drop down list of 5 items each varying in price is there a way i can create a list so that if a specific item is selected the relevant price is displayed in a different box on a form?

Cheers
Mark

 

[Remou]

Hi
I think this may help: thread702-923804

 

[BillieBurgess]

I have a form that uses a dlookup function. However, I also have the following:
A Table with Part Information, for example: tblPart
tblPart has the following field:
PartNo, PartDescription, PartCost, PartInvPrice

On my form, I have a combo box that refers to the part field in tblePart, example, ComboPartNo.
Then on the AfterUpdate Event for the ComboPartNo Control I have the following code.

Private Sub ComboPartNo_AfterUpdate()
    Dim TxtBox As TextBox
[COLOR=green] ‘Set the txtbox = to the control where you want the price to automatically update [/color]
    Set TxtBox = Forms![FormName]![ControlName]

    TxtBox.Value = DLookup("[PartInvPrice]", "[tblePart]", "[PartNo]='" _
        & [Forms]![FormName]![ComboPartNo] & "'")
End sub

 

[markswan20]

Thank you for your posts,

I'm a little confused by both but i'll have a go and see what i can do.

Thank You
Mark

 

[TheAceMan1]

How are ya markswan20 . . . . .

Include the [blue]price field[/blue] in the combobox then:

[blue]Me![purple][b]TextboxName[/b][/purple] = Me![purple][b]ComboboxName[/b][/purple].Column(2)[/blue]

You may have to play with the column number to get it right.

Be aware: the [blue]column index starts at zero[/blue] and includes any hidden columns in the [blue]Column Widths[/blue] property.

See Ya! . . . . . .