default values on form

[lloyd33]

Hi All

I have built a form based on two queries, the form does not contain a sub form. In table design I have assigned default values for my fields. Now when I create the form using auto form. Table 1 fields default values appear in the text boxes on the form when I begin to create a record. However the fields that belong to the second table their default values do not appear. The only way I can get the default values to appear is to enter them again on the property dialog for the text box on the actual form.

Any thoughts? I'm using Access 2000.

 

[lloyd33]

Default Values PT2

Sorry Pat my wording was wrong. The form is based on one query but the query contains two tables. The default value for the second table is not automatically displayed on the form when I create a new record, it is for table one.

 

[nuttychick]

Lloyd,

Have you tried adding the validation rule to the fields when they are on the form rather than in the table design.

I was trying to make the default value of a date field 2 months from another field, but had to make this default value when I created the form.

However it may be different if your default values are not calculating anything.

 

[lloyd33]

Thanks nuttychick I think you have simulated my problem. Adding to the form seeems to be the only way around this.