Add record in sub form. (1 Viewer)

R

raghuprabhu

Registered User.

Local time

Today, 09:34

Joined

Mar 24, 2008

Messages

154

• Jun 19, 2011

• #1

I have attached a small database. When I try to add a new record I am getting a warning “Field can not be updated” when date is entered in the eDate field. Secondly there is no code behind the “Add Record” button. On clicking this button I want to add a new record in the sub form, how do I do it? I want to remove the navigator button at the bottom of the sub form.

Thanks.

Raghu

 

Attachments

• AddRecordInSubform.zip

  61.4 KB · Views: 91

ansentry

Access amateur

Local time

Tomorrow, 02:34

Joined

Jun 1, 2003

Messages

995

• Jun 20, 2011

• #2

Raghu,

Have look at your db now. I have created 2 new forms frmCustomer & sfrmAccounts. Open FrmCustomer and you will see what I have done.

 

Attachments

• AddRecordInSubform.mdb

  396 KB · Views: 104

R

raghuprabhu

Registered User.

Local time

Today, 09:34

Joined

Mar 24, 2008

Messages

154

• Jun 20, 2011

• #3

That was a very good solution.

Thanks once again.

Raghu

 

ansentry

Access amateur

Local time

Tomorrow, 02:34

Joined

Jun 1, 2003

Messages

995

• Jun 20, 2011

• #4

Raghu,

Glad to help, something I forgot to mention, when you open my subform you will note that some of the controls have a yellow background - these are the ones I have set to visible = no. Also have a look at the small amount of code behind the subform - all for re-query

Good luck with your project.