Search results

ok i want my form to be look like this

i want to create a form using 4tables. ive done it before and it is successful. but when im create a table with concatenated key, then i cant build up a form. i mean i can but the form does not appear. why is that? n how can i create the form with those 4 tables without using a subform?

ok now ive done what u r saying. but another problem is, why i cant build a form? i made a form by 4 tables. but the form does not appear in a form vie. why is that?

i mean, can u help me with this? i have 6 products maximum for each project. how can i create a table for thaT?

if i dont have that kind of table, then how can i do that? i mean, i have 6 products. or u mean, 1 for each?

i have a combo box that be link to another form to be fill in if new record been entered. but if theres no record, i will receive the error msg,"the microsoft jet database engine cannot find a record in the table "Sub Detail" with key matching fields. here i attach my db

okay i think now i know why. if i just type in the vb window, there for sure the error will appear. i need to type for each. thanx a lot john. u helped me a lot

n plus, why theres still an error? i have 5 combo box to do the same thing. the 1st was ok. but the rest was not ok. shud i change something in my coding?

the code that uve attached above

n another problem is, whenever user have done with the updating part, then they will go back to the previous form, the last data still not in the list. means, the combo box is still not updated. why?

urmm.. what i mean is, ok i have a combo box with a certain list. my user request for that combo box. but let say the user want to add new data to the combo box, it will save automatically. how to do that?

thank you so muchhhhh

i have a combo box with a certain list. but if a user enter a new data into the list, then i cant be save to the combo box. is there any way that i can save the new data that been entered by the user by using the same combo box?

how? i dont know and dont understand

and another thing is, i have a form with the field name id, whenever a user fill in a certain id, then i want all the details be appear. how can i do that?

and another thing is, i have a form with the field name project_id. then whenever user insert an id, i want all the detail to be appear. how can i do that?

and another thing is, i have a text box with the project_id in the form. let say whenever a user type an id into that text box, then all the detail will appear. how can i do that?

i have a command button on the form with the caption "add new record". i want the user to click that button then all the field in the form will turn blank. how can i do that?

ok. i already found a solution.. thank you so much john..=).. and now, if i add new data to the combo or list box, it will not save to the database. why is that happen?

ok here is my attachment