Combine two inputs into one cell

[Marcel2586]

Hello,

How do i combine two results from a form into one cell.
What I want to do is this,
I have a form populated with a textbox named quantity, where I can fill in a number.
And I have a combobox named measurement with EA, Centimeter, Meter, Foot, Gram.
I like to combine the two results into one cell from column C without creating a temporary measurement cell.

So the result in column C reads 25 EA. or 10 Gram

I like to say thanks in advance.

 

[Marcel2586]

Have a look at this video I did recently:-

MS Access Get Info From a Combobox 1: http://youtu.be/RMUtsFhNAzI

Dear Uncle Gizmo,

Thank you for your replay, but there is a miscommunication going on. i had to have mentioned that i was building this in Excel. But your information is handy for my second project in Acces.

 

[Libre]

I think you're looking for the concatenate function.

=Concatenate (cell address of the qty, cell address of the measure)

If you're writing this in a code module and you want to address the text box and combo control, then the VBA is as follows:

 yourVariable = txtQty.value & cboMeasure.value