Carry Data over to the next record

[mellay]

Can anyone tell me how to carry over the same data in a field to the next (all) records in my database? For Example, the Judical Circuit for each of the records in my database will be "Southwestern". Is there any way to carry this information over rather than manually typing in "Southwestern" in each record? Thanks for your help!!

 

[JamesMeadlock]

I'd just change the default value of the field.

 

[UncleJack]

It sounds like you want a default value rather than a "carry over" which would imply the previous entry. Try setting the default value in your table field for Judicial District to "Southwestern." This will automatically enter that district on your form, but you will still be able to change it to Northeastern, etc. if you need to.

Cheers,

Uncle Jack

 

[mellay]

Thanks James and Uncle Jack for your prompt response! Your responses worked well for the field "Southwestern", however I now have a new problem. The next field I want to set as a default value is the review period: " 01-01-00 through 12-30-00". I can't get the program to accept such an entry in a field. I also have to use a field, Last Quarter, which would read "October, November and December 2000". These entries will change each month. Any ideas? I really appreciate your help!! Thanks!! mellay

 

[UncleJack]

Enclose dates is # delimiters, e.g. #2/3/99# and see if that works.

Why don't you set up a table like this:

QuarterID QName QMonths
1 First January, February, March
2 Second April, May, June

you get the idea

Store the QuarterID in your table and display either the months or quarter name. You can use a list or combo box to select and place the preferred quarter of the moment as the default value.

Uncle Jack

 

[mellay]

Thanks to Uncle Jack!! I really appreciate your help!! mellay

 

[jrjones666]

If there is a possibility of having more than just one input. You might want to use a combo box. You should still be able to use the default value but it will save time overall to use the combo box and have it display everything that has ever been input into this field. That way it is self-maintaining also.