Auto Entering Date Field

[joecamel9166]

I have a table with 5 forms bound to it. (all forms enter different to different fields)


This is for a repair database, so I have one form to receive, one to evaluate, quote, repair, and one to ship.
As each form filled out I need to enter the date to the table so it can be put on the report that generates the invoices upon completion.

What is happening now, is as soon as the record is created, I am getting that date for all date fields.

Thanks!

[Bob Fitz]

Never seen a useful db with just one table. Is your db properly normalized.

[joecamel9166]

I believe so. There are more than one table, but this one just holds the data for each unit that comes in. I also have customer table, parts table, etc.
Everything relates to the UnitID which is the primary key. Do you think it would be better to break everything down to individual tables for each step? I feel there would be a lot of redundancies that way.

[joecamel9166]

P.S. I am redoing our database that was originally written in Paradox 4.5

[Bob Fitz]

What is happening now, is as soon as the record is created, I am getting that date for all date fields.

Do you mean that each record has more than one date field or that you have one date field for each record and the data in this field is being changed for all records when you create a new record.

[joecamel9166]

each record has more than one date field

[Bob Fitz]

Just to be clear

each record has more than one date field

each of these fields changes when a new record is created?

[joecamel9166]

yes that is correct

[Bob Fitz]

When are these other date fields populated, when the first date field has data entered or perhaps when the record is saved.
Are they all the same date
Could it be that you have some code that is setting their values

[joecamel9166]

I am using the now function on all date fields. When I close the first form, it saves and that's when all the date fields get populated. I don't have any other code in it

[Bob Fitz]

I'm guessing that you're using the Now() function as the Default value setting of each field in the table properties. If so, try removing it and use it as the Default Value setting of the control on each of your forms.

[joecamel9166]

Got it. Thanks!

[joecamel9166]

OK so this solution worked for the first form with a new record.
Now I am working on the rest of the forms.
(Each record has a receive date, eval date, quote date, repair date, ship date)
When I open the eval form, all the data I need to enter can be entered manually, No problem there, but I want the date field to be automatic.
The only way I can get the date field to be inserted with the Now() function is to have it go into an unbound textbox.
As soon as that box is linked to the control source, nothing happens.

[Bob Fitz]

Can you attach a copy of your db for us to play with.

[orange]

Can you give us a description of your business? An overview of a "typical day at the office" so to speak. As Bob mentioned, rarely do we see an operational database application with a 1 table database.

Yes I think posting a copy of the database would help us put your post into context also.

You may find this free data model of an Equipment Repair Business from Barry Williams'site helpful in organizing your data.