I cann't entry data,But i have need it.

[meenctg]

I have a main form. In main form i have some field.
InvID (Auto number) (PK)
Name(text)
Pay(currency) (Required)
In main form i have a sub form relation with InvID
lineID (auto num) (PK)
InvID(number) (R)
item name(text)
Price(currency)


Problem: When i entry data InvID and name and when i click on subform for entry data it's show a msg for required field. But i wanna InvID,Name,and fill out subform then i will fill up Pay field.

What can i do ?
Any body help me? please

 

[Alansidman]

Have you set up a parent child relationship between your main form and your sub form?

 

[meenctg]

Have you set up a parent child relationship between your main form and your sub form?

i don't know how to will i do this.
would you tell me,please?

 

[Galaxiom]

The main form record will be saved when you move the focus to the subform. Any form validations or table constraints are applied to the record at this point.

You cannot do what you want unless you change Pay from being a required field.

 

[Alansidman]

look here

http://www.functionx.com/access/Lesson36.htm

 

[meenctg]

The main form record will be saved when you move the focus to the subform. Any form validations or table constraints are applied to the record at this point.

Actually i wanna the last field of main form Pay (R) will fill at last.
After fill up sub form i wanna fill up Pay field.

It is a Invoice project so user will entry (Pay) when he get the grand total of sub form.

 

[Galaxiom]

Actually i wanna the last field of main form Pay (R) will fill at last.
After fill up sub form i wanna fill up Pay field.

Sorry, as I said above. This simply cannot be done (with Access bound forms) with that constraint in place.

It would work if you removed the constraint from the Pay field.

Alternatively, many invoicing systems will use a separate Payments table. This structure also supports making payments separate from the invoice. Often a junction table will also be used to support allocating payments to multiple invoices.