VB6.0, DataGrid control

Hi Experts,

I have a project developed in VB6.0 and am using Access2000 as my backened. I have a PurchaseMaster form which displays the purchaseproductdetails in a datagrid, I have placed a combobox on this grid which display the PartNos of the products, when the PartNo is selected in the combobox the respected Productdetails should be picked up from another table and displayed in the datagrid.. I am using a combobox making it visible on buttonclick_event of the datagrid but my problem is when the user selects the PartNo from the combobox, the productdetails do not get displayed in the grid but if I enter the PartNo manually i.e. without selecting from the combobox the productdetails get displayed properly. I have written a code showproductdetails which executes when the PartNo column on the grid is updated...

Can anybody please help me sort this problem as I am stuck... :(
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sounds like your part numberin the combo is a text/integer that is incorrect format for your query? What data type is your part number? What data type is your combo?
twinkle2003Author Commented:

My partNo is is of "text" datatype.. and my combodata type is also of "text". Like I mentioned my query works fine, I get the data displayed in the grid if I enter the PartNo directly in the partno column of the Grid, but if I select teh same PartNo from the combo nothing happens, my focus moves to the next control without giving any results...

Here are a few questions you should ask yourself.

Is there a recordset being generated from the combo?
Are you refreshing the grid to populate it with the data from the recordset after bing selected from the combo?
How is the combo populated?
Are you trimming your variable to eliminate leading and trailing spaces before inserting into the combo, Trim()?
Does the same query run for both a manual entry and a combo entry?
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

twinkle2003Author Commented:
Hi guys!

I have worked out a solution myself, and it works just fine...

For future reference how did you solve your problem?
twinkle2003Author Commented:
I wrote a procedure "ShowProductDeatils" which picks up record from the table categoryMaster based on the PartNo selected in the combo and then I pass this field values retrieved to each of the datagrid column, I calls this procedure at the comboclick_event...
PAQed with points refunded (50)

Community Support Moderator

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.