Linking Split Tables

[Guest]

I have an spreadsheet I've imported to Access with a few columns of repeated
data. I've split these repeats into seperated tables using the analyzer. This
makes for easy searching in a form/query using a combo box as it eliminates
repeats in the combo box itself.

My problem lies in updating and adding new records. I'd like to be able to
add a new record via a form and have it update the underlying tables, which
will inturn update my combo boxes used for searching and at the same time.

I'm fairly new to Access so hopefully this makes enough sense...

Thanks

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com) are two small sample databases
called: "NotInList.mdb" and "NotInListAlternatives.mdb", which show you how
to do this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[John Vinson]

My problem lies in updating and adding new records. I'd like to be able to
add a new record via a form and have it update the underlying tables, which
will inturn update my combo boxes used for searching and at the same time.

If the Combo Boxes are based on the table, you probably needn't do
ANYTHING to have this happen. Just base a Form on the table that you
want to update (or on a query based on that table, if you want to sort
the records or filter them). What specific problem are you having
doing so?

John W. Vinson[MVP]