Search results for query: *

Yes thanks but that means i have to code every button with the code which is no point need to havea way where onec it is done th user can just add or change departsments as he wishes and i dnt want to open the form products it doesnt need to i can get the products listen from the bttons...

Thanks Majp for the reply Right i have got the department buttons working using the adodb connection which it picks the button captions up from the table departments then is where i have had a problem and i think you have cleared if i click a department button say fish i cant have one routine...

Hi MajP There were a few errors , first of all it didnt reconise the dao.recordset for some reason but i am managed to figure it out and now when i load the form the items from the department load up, but only one prob, in vb you create an index say cmddep, now if you add any code to that any...

HI Thanks for the reply Remou but i have been trying it out somehow it doesnt seem to work, i dont know if i am doing something wrong but it comes up with all sorts of problems, do you have an example i can work by. thanks

Hi there I am wandering if anyone could help me out on this matter, i ahve 2 tables at the moment, a departments table with the field depart no and name and a products table with prod no, name, price, department name, now say i have 10 departments then i would want to create 10 command buttons...