Editing by Combo Selection not record?

[cassidylm]

Hi,

I am trying to update prices changes for products in my inventory database, and am stumped.

I select a vendor, which then populates the product name from which I can then select the product I want to update. From here, it populates what the current prices are. I then can type the new price into the next box, but what happens is that it doesn't change that Product it changes the 1st record.

Can anyone help!

 

[CEH]

Just glancing at your screenshot I'd guess your problem is in the "Update Prices Here" section. I am guessing those are unbound textboxes with code on your "save changes" button. As I'm sure you'll hear.. It's very hard to tell just from a screenshot and not seeing the actual DB, queries and relationships. Have you tried changing the price in your "Current Prices" area to see if it changes the correct item?

 

[cassidylm]

How can I send my DB to you then?

 

[CEH]

Most people just zip the DB and post it here... Just like you did the screenshot.