Reply to thread

Message: <blockquote data-quote="R_L" data-source="post: 3787453" data-attributes="member: 16427">hmm machan.. meka diga wediwei da manda.. oke wenne oya products danawa eka table ehekata.. ita passe ekata adala capacities assign karanawa.. then in the place where u want to have wat u wanted to work u use a small code.. first u make the table where u want this to work.. one field (products) shud be lookd up from the products table.. othr one normal text box callled capacity.. then u create a form based on that... u then change ur capacity textbox to a combo box.. eka karanna u have to select the capacity text box an riightclick an go to Change to> Combo Box.then go to the Products field on the form. this is the value on which ur capacities will change.. different values in capacity depend on this products value..go to the Properties of the Products field.... go to the After Update option and select the dotted box... select Code Builder.. u will get two lines of code like this seen:Private Sub products_AfterUpdate()End Subu then have to enter a code like this inbetween the two lines above:Me.capacity.RowSource = "SELECT productcapa.[spec detail] FROM productcapa WHERE (((productcapa.[product])=[products]));"                        to explain this code means that the row source or the values displayed on your capcities dropdown menu will change according to the value selected in your products fieldproductcapa is where u assigned the capacities.. that means assigned all the values that aany product can have.. ex: flash ekak can have 1, 2, 4, 8GB, etc...so it selects those values WHERE the product name is equal to the name selectd in the current form.</blockquote>

Verification: Winadiyakata thappara keeyak tibeda?

Top Bottom