Multi value list box to update text box

[munkeyroot]

Hi Everyone
just a quick query
is it possible to update a text box from a multi value list box?

i have a roles table with role_id, roles, charge rates. at the moment i have it set on a combo box, which once i select a role it shows the charge rate a text box labour_£. i have done this on an after event me.txtlabour = me.cboRoles.column(2).

though i would like to use multiples of the roles and give me an over all charge rate, instead of creating multiple roles tables?

hope this makes sence

munk

 

[Ranman256]

You wouldn't.
Instead of adding many things to a single text box,
You'd add 1 item to a sub table. A 1 to many relationship.

User would dbl-click the single item listbox,
This would run an append query to add that item to the sub table.

 

[munkeyroot]

ahh of course, thanks Ranman star mate

munkey