Hi,
I have to use the table(PRODUCTION) already generated in MS Access in which all fields are of TEXT type.fields like (orderdate,palletno,customercode,itemno,pono,carto n,pcs,totalquantity)Now i have already some data in table like 6000 rows.Now in that some fields are blank.
Now I have created one Form in MS Access in which there are three ComboBoxes.1st one is independent,2nd one is dependent on 1st one and,3rd one is dependent on both 1st and 2nd. Now I have to select (custcode) from 1st comboBox after that it will generate list for 2nd combobox.now when i am selecting (PONo) from 2nd combobox it will generate list for 3rd combobox depend on choice of 1st and 2nd combobox.So at the end i have the list of whatever i selected from comboboxes.
but when i am selecting value from 1st combobox there are some blank fields also in that selection.So if I select that blank field it have to show me the list depend on it.but it show me just blank result.
This is the example so u can understand easily
EXAMPLE
Table:-PRODUCTION
custcode PONo ItemNo Price
abc 123 456 500
xyz 423 400
abc 789 500
asd 456 550
abc 450
rat 123 500
abc 456 300
sad 200
jkl 456 798 520
abc 798 450
abc 900
in the 1st combobox i have list
abc
xyz
asd
rat
cat
sad
jkl
now when i am selecting "abc" from 1st combobox it show me the list for 2nd combobox which is
BLANK
123
789
so when i am selecting "BLANK" from 2nd combobox it has to generate list for 3rd combobox which is
BLANK
456
798
(but it shows nothing in my case.)
now when i am selecting "BLANK" from 3rd combobox it has to show me the last result like this
450
900
(but instead of that it will show me nothing)
so what to do to select that blank field.?
I can't change the table because someone already made it and now i have to use it and also my project's data are in that table.so plz if there is any possible solution plz give it to me.Any solution appriciated.plz help me
.