New Record

[=TB=]

I am probably missing the obvious here but it something that has me really stumped. Any Help would be appreciated.

I have a form with a linked subform. I need a way of when I add a new record the record is created automatically. What happens at the moment is the user can by pass any of the fields on the main form and go straight to the subform, which means that those records they add have the risk off being lost off the Main form as they are no longer linked to the main form.

Do I make sense? Am I being dim.

Thanks in advance

 

[doran_doran]

Northwind Database Sample....

Open Northwind Database, then open the form called "orders" which is a subform called "Orders Subform". Go all the way to the last record, then click again on the forward arrow to create a new record. YOU SHOULD GET YOUR ANSWER.

Here is link from Microsoft for Sample DB
http://www.microsoft.com/downloads/...familyid=c6661372-8dbe-422b-8676-c632d66c529c

Good Luck
Dianna

 

[Rich]

Use the OnEnter event of the subform to validate the Main Form entries.
If IsNull(Me.SomeControl) Then
MsgBox "Enter main detail first dummy!"
SomeControl.SetFocus
End If

 

[=TB=]

Thankyou that works, I was heading in the right direction except I was using


If [SomeForm].SomeField = "" Then
MsgBox "Enter main detail first dummy!"
[SomeForm].SomeField.setfocus
End If

Which did absolutely nothing lol.

Thankyou both very much.