autofill box is always updated as 0.

[mejia.j88]

like many here, im new to access, and i have set up a form that auto-populates two fields.



the "part number" combo box shows three things, Part number, Stack size, and Cut size.

upon choosing the part number, stack size and cut size should be automatically filled.

Stack size works great, although, cut size always has the value 0, regardless of what should be there.

below is the code im using:

Private Sub txtpart_number_afterupdate()
Me.txtStack_Size = Me.txtPart_Number.Column(1) + 2
Me.txtCut_Size = Me.txtPart_Number.Column(2)
End Sub

help please, i don't know why this is happening.

[pbaldy]

Does the part number combo row source include that field? Is the column count property of the combo appropriate to the number of fields in the row source (in this case it needs to be 3)?

[mejia.j88]

The row source for the combo box is a query i created from a table containing the Part Number, the Stack Size, and the Cut Size.

My column count is set to 3; and the table with the part number comes from a different db. it's linked to the one im working on now.
:X

another note: on my code, if i change the line

Me.txtCut_Size = Me.txtPart_Number.Column(2)

to:

Me.txtCut_Size = Me.txtPart_Number.Column(1)

the 0 value goes away, and it is replaced by a number from the column im calling.

[pbaldy]

What type of value is cut size? If it's a decimal, it may be rounding to zero if you put it in a field expecting an integer. Can you post the db here, or a representative sample?

[mejia.j88]

Cut size is a decimal; i have the field to receive general numbers with 4 decimals on display.

unfortunately I am required full disclosure with our information, hence I cannot post the db or a representative sample.

[pbaldy]

What is the data type of the field you're putting the value into? The format doesn't matter if the data type is wrong.

[mejia.j88]

i changed the data type from number to text and it's working now, even though all of the data from the query are numbers.
strange?

[pbaldy]

I suspect the field size was integer or long integer, which could have caused the problem. You might try currency, double or single depending on your needs. Be forewarned that single and double are floating point, and can have issues. For instance .25 could get stored as .2499999.