combo data

[John]

i use dropdown (combo box) to enter data for example: -
in form
i click : item no (combo box)
auto update : item name
but
in table
item no is updated, but item name is not updated.

pls help me !

thanks

JOHN

 

[Jeff Boyce]

John

Is ItemNo defined as a Unique value? (It sounds like it isn't).

In your combo box, are you binding the ItemNo or the ItemName?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John]

Hi Jeff

ItemNo defined as number
combo box binding ItemNo

Thanks

JOHN

 

[Pieter Wijnen]

I Think we might have a denormalized table issue
He wants to store Both values from the combo (bad practise) or to display
the name on the form (good practise)
either way:

Sub Cbo_AfterUpdate()
Me.ItemName.Value = Me.cbo.Column(1) ' zero based
End Sub

Pieter

 

[Pieter Wijnen]

I Think we might have a denormalized table issue
He wants to store Both values from the combo (bad practise) or to display
the name on the form (good practise)
either way:

Sub Cbo_AfterUpdate()
Me.ItemName.Value = Me.cbo.Column(1) ' zero based
End Sub

Pieter

Hi Jeff

ItemNo defined as number
combo box binding ItemNo

Thanks

JOHN

--

 

[John]

Hi Pieter

i am not good in visual basic. I do not understand your advise, pls explain
other way

JOHN

 

[John]

Hi

my question is I key in data in form

itemno (combo box)
itemname (auto appear)

after key-in, data record in form but check in table, itemname is not
update. in report to print out itemname is "blank"

Pls help me

Thanks
JOHN

 

[Pieter Wijnen]

On the properties page for the cbo find AfterUpdate Event -> click the
builder (...) -> select: Event Procedure -> ok
& type the code (using your controlname for the combo, instead of cbo and/or
ItemName)

Pieter

 

[Pieter Wijnen]

On the properties page for the cbo find AfterUpdate Event -> click the
builder (...) -> select: Event Procedure -> ok
& type the code (using your controlname for the combo, instead of cbo and/or
ItemName)

Pieter

Hi Pieter

i am not good in visual basic. I do not understand your advise, pls
explain
other way

JOHN

--

 

[John]

Hi Pieter

I need your help, pls advise me

Thanks

JOHN