Cascading Data...I think

[Ian-W-]

Hi, im creating a database for my company, im by no means an access whizz and this is the first db i have created. It is working but i know i could get it alot more streamlined....

heres a screen shot so i can explain what i want to do...

I want to be able to click the drop down stock code box and the description, and cost price to be automatically entered dependant on the cose i select.

Im sure that this can be done so any help would be greatly appreciated.

Thanks

Ian

 

[Pauldohert]

Don;t quite know where your drop down stock code box is?
Is this a datasheet view of a form ( I have never worked with these) ?

A simple solution

Have the stock code as a combo box - three columns code,description, cost

after update of combo box

description = combobox.column(1)
cost = combobox..column(2)

assuming the code has only one dscription and cost?

Not sure if that was what you were trung to do?

 

[Ian-W-]

The stock code, description etc are in a table.

I tried using combo boxes but the problem with them is that I need the form to clear when I move to my second record. When I tried using a combo box the main form moved to a new record but the combo box kept the same data.