Insering new records

[rosh]

Hi,

I am new to access, i have a insurance database with customer table and policy table.I have created a form which displays customer as well as existing policy info. I want to have 'add policy' so that it open policy form to insert new policy

My problem is that when i add policy subform it again shows existing policies of the customer.How can i change that the subform will show only to insert new policies of customer


Please help

Thanks
Rosh

 

[Access Hero]

Open the properties for the sub-form and set "Data Entry" to "Yes".

 

[rosh]

Thanks so much

 

[Access Hero]

No problem. Always glad to lend a hand.