Populate Field in a Entry Form

[BADebbie]

I have a Entry Form, and in this form we need to enter the Part #, and then the field below should populate with the correct description of that part number from the table it is in. The correct description is not coming up correctly when I hit enter. I believe it is just going to the next record instead of choosing the correct description. How can I make this populate correctly?

Part#	Part Description	Quantity
1	A/C ACCUMULATOR

[ranman256]

The part# entry should be a combo box. When the user enters the part# it will automatically fill in description via the code below....
the combo box has 2 columns; part, description.
when the user presses enter ,the code loads the item in the second column:

sub cboPart_afterupdate()
 txtDescr= cboPart.column(1)      'Note,in VB columns start with zero
end sub

[BADebbie]

That didn't seem to work. I can only see 1 column, which shows the Part #. Do I have to put in the code somewhere, or does it create it in the background when I create the Combo Box?

[aytee111]

Go to the AfterUpdate property for the combobox, select Event procedure, and copy the above code. Remove the ".column(1)" to get the first column.

[BADebbie]

I guess I'm doing something wrong. It still picks a random description.

[ssanfu]

On the DATA tab of the Properties dialog box -> What do you have as the ROW SOURCE property of the combo box? Should be a query or SQL.. post the SQL...

On the FORMAT tab of the Properties dialog box -> What is the Column Count property value? Should be 2......


Or you could post your dB......

[BADebbie]

Data Tab Row Source: SELECT [Parts].[Part#], [Parts].[Part Description] FROM Parts ORDER BY [Part Description];

Format Tab Column Count = 2

[aytee111]

Is the bound column property set to 1?

[BADebbie]

Yes it is.

[ssanfu]

Would you post your dB?

It is really hard to give a good response when we don't have any idea of your tables structures, the form design or the fields involved.
Only need a few records for testing.

[BADebbie]

I tried to attach it, but it is too big.

[BADebbie]

I can't make it any smaller to attach. I'll keep trying.

[BADebbie]

I'm down to nothing and it is still 884K, which is too big.

[ssanfu]

Do a "Compact & Repair" , then Zip it.

Max size of Zip file to attach is 2mb

[BADebbie]

Sorry to be a pain, but I have never zipped a file.