combo box question

[mifee]

hi..

i had form like in pic..

what i want to do is..when user select product code in combobox,the serial num combo box only show that serialnumber base on productcode cbo

thanks for yur helps

 

[John Big Booty]

I suspect you are looking for a Cascading Combo Box set up. Also search this forum on the subject.

 

[mifee]

after searching & trying..still cannot get the solution...

let me breif more...

i have this tbl..

tblProductCode
- ProductCode
- Product Description

tblStockIn
- productID
-productcode
- Quantity
- SerialNumber
- Invoice Number
- Price
- Date In

tblStockOut
- outID
-productcode
-serial number
-quantity


so..at frmStockOut..(attached before)

there productcode user will select using combo box..
now.. im try todo cascading cbo..
after trying many code..it seems not working..

pls help me..

 

[Isskint]

mifee the answer is out there, honestly.

Ok, option 1, add a where statement to your serial num combo box rowsource, to restrict the entries according to a linkeed field in combobox.[product code]

option 2, use the afterupdate event of combobox.[product code] to restrict the entries in serial num combo box

 

[mifee]

i tried opt 2 before maybe wrong code...hmmm...

 

[Isskint]

i tried opt 2 before maybe wrong code...hmmm...

Can you post the code you have?

 

[mifee]

deleted already... lol..