MS access issue

[Willie]

I Have a main form called table one has 3 fields an autonumber as primary key and i have a subform called table 2 has 3 fields one an autonumber a primary key , second is an integer which is equal to table 1 primary key, and third is a text with default value set to N/A

i want when the user enter info in the main form and save it, the subform automatially add new record and save it with default settings

so far what s happening , that the related field in the subform to the main, is getting change but record is not getting save in the table 2


plz assist

[June7]

Never tried or seen anything like this.

You want this to happen only when new record on main form? Why is middlename in a different table?

[Willie]

is there a way around it?, to make it work,

[Willie]

i was doing a test only for another project shown in the picture, where I have a main form and a tabcontrol for subforms and the data are optional, however i still want the record to be saved by default in case the user didn't enter any, for Report purpose

[June7]

Record is not initiated until user does data entry. Default values do not initiate a record. So cannot check if record is Dirty because there is no data entry.

Maybe:

If Me.NewRecord Then
CurrentDb.Execute "INSERT INTO table2(tblID, middlename) VALUES(" & Me.ID & ", 'N/A')"
Me.subformcontainer.Requery
End If

The real trick is figuring out what event to put code into. Maybe the AfterUpdate event of main form.