A
alan fisher
Hi All, First I know this is the wrong section but the
right one is unavailable. Here's my question:
I want to copy the tables I use for combo boxes to the
users front end every time they open it yet still be able
to update the backend copy when an item is added. What I
am going to try is, place some code in the On Load event
of the startup form that first deletes the tables then run
a number of Make Table queries to get the tables loaded in
the front end. I will also code the Not In List event of
the combo boxes to update the frint and backend tables as
usual. I will experiment to see if there is too much of a
delay on startup but want to know if there is a better
proven way to do this. Thanks for any help.
right one is unavailable. Here's my question:
I want to copy the tables I use for combo boxes to the
users front end every time they open it yet still be able
to update the backend copy when an item is added. What I
am going to try is, place some code in the On Load event
of the startup form that first deletes the tables then run
a number of Make Table queries to get the tables loaded in
the front end. I will also code the Not In List event of
the combo boxes to update the frint and backend tables as
usual. I will experiment to see if there is too much of a
delay on startup but want to know if there is a better
proven way to do this. Thanks for any help.