Date being entered automatically?

[Radion]

Hi all,

I'm working on a library database for a small collection.

I have two fields, 'Date Out' and 'Date IN'. Is it possible that whatever date is written for the date taken out, I can set the 'Date IN' to be 7 days later than that date?

Thanks in advance.

 

[RuralGuy]

You really *don't* want to store this calculated value. Just calculate it in a query whenever it is needed.

 

[Radion]

Thanks for the suggestion. Just one more question.

Is it possible that when I type in a something in a field, I can change the value of another (yes/no) field?

So if the field is empty, the field will be set as Yes. And if something is typed in, it'll be set to No.

 

[RuralGuy]

Sure! Use the AfterUpdate event of the control and put similar code in the Current event of the form.

Me.CheckBox = Len(Me.YourControlName & "") = 0

 

[neileg]

Is it possible that when I type in a something in a field, I can change the value of another (yes/no) field?

So if the field is empty, the field will be set as Yes. And if something is typed in, it'll be set to No.

Same comment as before. You can test the field for contents any time you like, so you don't need the yes/no field.