Ive asked this question in the access thread area also: just want to see if VB coding could help to do this in a neater better way.. the answer I got was use sub forms but if im honest its not the desiered effect I want on my database..
Hi all is it possible to get more then one frm / tabel to show its controls Basics:
I have 5 tables I would like to update but rather then create mutiple forms to update and use cmdbuttons to open them individually I thought it would be neater to have 5 tab control pages so you can tab to the product or info i need (if that made sense)
Ive tried it but dont seem to get it to work, im new to VB but would love to know if it is poss or a hint at least how to do this.. not asking for anyone to do this for me as I need to learn but need a pointer or too even if its a title of a book to help me or link to a web source that can take me through it step by step..
so say I have
tbl1 with three text boxes one drop down call it tblProduct
tbl2 with 2 drop downs and 4 text boxes call it tblPrinters
etc.... so tbl1 on tab 1 and so on
Thanks in anticipation..
Sal