combo data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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


John said:
Hi Jeff

ItemNo defined as number
combo box binding ItemNo

Thanks

JOHN



--
 
Hi Pieter

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

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
 
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
 
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

John said:
Hi Pieter

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

JOHN



--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COMBO 2
COMBO UPDATE 3
COMBO DATA 1
ACCESS COMBO BOX 9
Combo Box and First Record 5
Result on Combo box return prior record data 4
Combo box contents not updating 1
Search in combo box 3

Back
Top