Filling in text box from another text box

[Cobra]

Hi,
I'm trying to create a database for my nearby gliding club but have come across a problem when trying to fill in a text box from another. I have used one text box to find out what the total time for a flight is (landing time - launch time). However to do this, I created a text box which uses the control source as landing time - launch time.

The next part of it was to create a hidden text box which the control source is linked into the table. The part which I am stuck with is that I don't know how to fill this in from the text box working out the total flight time.

Cheers in advance

 

[KenHigg]

I think this a case where you are storing a calculated value which is not recomended in the db world, but rather to simply calculate it on the fly where-ever you need it.

 

[Cobra]

Ok, thanks for your reply.

The only problem is the end user (the club) requests a total time for the flight. Is there any way which I could do it a different way which would be better for the database to cope with?

 

[Cobra]

Any ideas?