Get current data and future data from a table into an updatable form.

[kathryn]

Sorry, his is a duplicate post; I posted this to the Forms forum before I realized that it is a query problem.

OK this one has me stumped. I am sure that it is simple, but I can't see it. I have a table with data similar to:


ID BranchCode BranchAddress AddressEffDate
--- ---------- ------------- --------------
1 AL001 123 Main Street 9/1/00
2 AL001 234 Elm Street 10/1/00
3 AL001 345 Oak Street 12/15/00
4 AL002 456 Fletcher 1/1/00
5 AL003 567 Fowler 2/1/00

I need the update form for this data to show the current data AND any future data. If I don't show the future data, the woman doing data entry will just keep entering it over and over. The data must be updatable, which is what is tripping me up.

I am thinking, (me the queen of database design!), that this should be broken up into two tables, but I REALLY don't have time to do this. (I know, I know, it's better to do it right, but I am swamped.)

Anyone have an answer?????



Kathryn




Kathryn

 

[MichaelRed]

Asked and answered in the Forms Forum.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over