Enter 2 columns into 1 text box

[Cdogg]

I’m new at this and the more I get into it the worse it gets.
I would like to take 2 columns from a combobox and enter them into 1 textbox in line.

Also can I send the contents of a textbox to 2 different tables.

Thank you very much for your help.

 

[Alexandre]

Not pretty much sure why and in what context you would like to have in a textbox the content of two columns from a combo .There should probably be a more direct approach (take the values directly from the underlying table(s)/query).
But in any case, let s say that you combo is called cbCombo and your textbox txTxtbox.

You could use the after update event of your combo to write text into the textbox:

Me.txTxtbox=Me.cbCombo.column(0) & Me.cbCombo.column(1)


As for your your second question, on principle you should not store twice a value in your database. This is likely to mean that you should review you database design. I suggest that you provide more details about what you have and are trying to do, so that we can help.

Alex

[This message has been edited by Alexandre (edited 12-26-2001).]