New record

[micropalla]

Hi everybody.

I would like to know if you can help me with this...
You know that when I open a mask it shows the first record I've in there.
Is it possible to show directly the new record I've got to put in ?

Thanks to everybody and have a nice day !!

Lorenzo

 

[SforSoftware]

You can give the command "DoCmd.GoToRecord , , acNewRec"

 

[Rogue Programme]

I have a quick question to extend on this.....

What command would i need to SetFocus on a particular field once create new record command has been executed?

Cheers

 

[namliam]

Me.fieldname.setfocus

 

[Rich]

SomeControl.SetFocus

 

[Rogue Programme]

Still getting an error.

It must be me going mad. All i want to do is insert a bit of code into an 'add new' command button so that it defaults to a specified field on the form.

I have tried the following and neither of then work.

Me.specifiedfield.SetFocus

Forms![specifiedform]![specifiedfield].SetFocus

Cheers

Mike

 

[Mile-O]

You may be trying to set the focus to the field and not the control bound to the field.

It's a problem that is going to happen if you don't start using prefixes to identify your different objects from your fields.

i.e. txt for textbox, cbo for combobox

 

[Rogue Programme]

Cheers!!

You were right Milo...

I did start prefixing my tbls, qrys rpts etc.. but not my txt or cbos.

That will teach me!

Thanks again.

Mike

 

[Mile-O]