Add new buttom

[List]

Hi, All,

I created "add new" buttom in the form that works in the main form. But It is not work in the sub form.

Any help?

Thank you a lot.

Joe

 

[LonnieJohnson]

Did you set the focus to the subform before you did the command to add a record to it?

Just a thought... ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[Aivars]

private sub cmdAddNewOnSubForm
DoCmd.GoToRecord acDataForm, _
Me.MySubForm.Form.Name, acNewRec
end sub

Aivars

 

[List]

Hi, LonnieJohnson,

I didn't set focus, but I have "autoNumber" text box.

Thanks again.
Joe

 

[LonnieJohnson]

Sorry, but I have to ask this...Do you have a Child/Master link set up between the two forms? ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[List]

Hi, LonnieJohnson,

Yes, I have a child/Master links. My form status is:

Main form -> subform -> another subfrm, that means the main form including subform, subform including another subform.

All forms have child/master link. My form works fine for all search combox, but only "add new" buttom not work in subform.

Any more ideas.

Many Thanks.
Joe

 

[Aivars]

Requery the subform after adding record on Main form. (Before you requery the subform you may save record on Main form)

Aivars

 

[LonnieJohnson]

If want to mail me a copy of your forms, tables and/or queries I can take a look at it. ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[List]

Thanks all. I already got it.

Joe