Subform .........please help

[sajidaziz]

my main form has CustID, name, address etc..i have a subform having the fields CustID, Receipt# .....to add new record on subform for the same custID i want a command button on main form.....when i click on the button.....focus should go to on subforms last receipt# + 1....
is it possible??????????

 

[Meltdown]

Me("SubFormName").SetFocus
DoCmd.GoToRecord , , acNewRec

...should do it

 

[sajidaziz]

thanx dear it works.....but problem is still there...
i want last receipt# plus one (Last record + 1)

 

[RuralGuy]

Try something like this <<air code>>

Dim NewReceipt As Integer
Me("SubFormName").SetFocus
DoCmd.RunCommand acCmdRecordsGoToLast
NewReceipt = [Receipt#] + 1
DoCmd.RunCommand acCmdRecordsGoToNew
[Receipt#] = NewReceipt