Recent content by lvr

Ok guys. Thanks. I tried you last proposition and I think it works (because i'm getting a new record, but not all the times I expected). I guess I have some trouble with events. I will check the rest by myself. Any to way to mark this topic as "resolved" ?

Hello Terry, Thanks for the effort, but it just doesn't work. I keep having this message that the command is not available "now". I was in DataEntry mode, I moved it to false, to no avail. I keep staying on the last record. I will do the "gotonewrecord" manually :(

Hi thanks for ideas ! None of these works. - DoCmd.RunCommand gives me "The command or action RecordsGoToNew ins't available now" - DoCmd.GoToRecord gives me "The object 'frmDistances' isn't open." I will give a precision: what i'm doing is to try to move the subform B to a new record from a...

Of course it works !!! The second example is numerical.

Thanks guys. It works fine. I'm just surprised that this doesn't seems to required all the time. For example this works fine: frm.lstPointA.DefaultValue = Me!idPointA

Thanks. And then ? How do I write that the DoCmd.GotoRecord must occur on the subform ?

Thanks Terry, but I want it to be the default value. What you suggest would start the editing of the record and this is not what I want.

Hello, I would like from my main form to move a subform to a new record. Usually I'm doing that like this: DoCmd.GoToRecord acDataForm, me.name,acNewRecBut here with the subform, I've tried to write: DoCmd.GoToRecord acDataForm, "MySubForm" ,acNewRecbut I'm said that MySubForm is not opened and...

Hello, I'm setting with vba the default values of the fields of my form. For some fields, I don't get the default value but a "#Name?" instead. As soon as I start editing the record (by typing some text in another field), the "#Name?" is changed to the default value of the field as set in the...