wilbola123
New member
- Joined
- Feb 9, 2006
- Messages
- 2
- Programming Experience
- 3-5
I have a big table in Access. I need to be able to bind a data adapter to more than one form. Is there a way to do this?
How to bind data adapter to more than one form
- Thread starter wilbola123
- Start date
vis781
Well-known member
Bind a dataadapter? You can't. do you mean a datagrid?
YEs... but you shouldn't be binding the adaptor itself.... if you are binding, it should be to the datatable/dataset.
If you declare your dataset in a module as protected (or friend)... then it will be available to all your forms. Then it's simply amatter of running the binding commands to get it all hooked up.
-tg
If you declare your dataset in a module as protected (or friend)... then it will be available to all your forms. Then it's simply amatter of running the binding commands to get it all hooked up.
-tg
wilbola123
New member
- Joined
- Feb 9, 2006
- Messages
- 2
- Programming Experience
- 3-5
how?
do i create a new module like this:
Module Module1
dim dataset1 as new dataset
End module
Im confused. Then how would I call it on the other form. Say I had a form1 and form2 and then would I have to write a lot of code to tie it in to the text controls?
do i create a new module like this:
Module Module1
dim dataset1 as new dataset
End module
Im confused. Then how would I call it on the other form. Say I had a form1 and form2 and then would I have to write a lot of code to tie it in to the text controls?
