if Open Form then New Record

[raffi]

hello, i have 2 forms using 1 conjunction table, is there a way of setting default value of the AutoNumber Text-box within a form to New ? when opening the form ?





thank you.

[June7]

What do you mean by AutoNumber textbox? This is a custom unique identifier, not an autonumber field?

Could set any value you want into the field.

How are you moving to new record row?

[raffi]

nothing i think i may have over complicated it, its rather simple, its just a conjunction table, embedded in a form where i can choose fields and click the new button and add another record, but im looking for a way, where when i open the form it will go to a new record automatically, much like opening a form in add mode, but i want to be able to edit also, so its edit mode but when i open the form it will show me a new record

which would look similar to something like, form> on open event, go to, new record,

[June7]

Code in form Open event.

DoCmd.GoToRecord , , acNewRec

Unless it is a subform, I think gets more complicated. https://www.accessforums.net/access/...red-40057.html

[raffi]

it worked ! thx !