date field has to be updated or each new record



Why would a date field in a form have to be updated for each new record that
is added. When adding projects to my form (I am doing a staffing by week
database) I have a WEEK#1 field that all dates are referenced from. Lets
say that I add 1111 to the form and I already had a project 1112. The next
time I open the form project 1111 will come before project 1112 but the dates
will be blank across the top of my form. This WEEK#1 field is referenced on
several different forms. Right now, I have a macro that updates this field
for all new records. It is cumbersome to keep going back and Updating week#1
for new records. Does anyone have any suggestions?

Thanks in advance,

Merlin
.



Relevant Pages

  • Re: Checking if your computer has the latest version
    ... Then reboot and try updating again. ... My SpywareBlaster Custom Blocking List: ... Prev by Date: ...
    (microsoft.public.windowsupdate)
  • Re: Spyware
    ... YW and happy Holidays. ... Thanx for updating the thread. ... Dave ... Prev by Date: ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Why you should never buy a car without a tachometer
    ... > in between so I can copy/paste it together and view the site? ... Or, much better and less cumbersome, make the long URL into a short one ... before posting it, by visiting www.tinyurl.com. ... Prev by Date: ...
    (rec.autos.driving)
  • Adding Sub Columns
    ... more than 10 rows of data, so that would be a rather cumbersome approach. ... Thx ... Dave ... Prev by Date: ...
    (microsoft.public.excel)
  • Forming a matrix
    ... It just seems cumbersome. ... Dan ... Prev by Date: ...
    (comp.soft-sys.matlab)