Hello,

I have build a simple 3 table database at my work for us to replace our ancient logbooks. We are using it and it works pretty good, that is my colleagues and I are happy with the end result.

but I am by no means an expert in this field and we have a small problem: when the form for logging is initially started it shows the first record in the table and my colleague overwrote that accidentally.

my question:

How to make a form default to new record rather then showing the first record from the table each time the form is initially opened?

in my search for the answer here I found a new term (for me) but its name already makes me think of a modification for my purpose: "switchboard"

I just made another form with buttons to start a form to fill in the appropriate table, that I would almost want call a switchboard

so perhaps my second question would be:

what is a switchboard?


Thanks in advance
Ron

there are two things.

1. you can code your form on On_Load event of your form

docmd.GoToRecord,,acNewRec

2. Or if you dont know how to code, you can set your form DATA ENTRY on DATA Tab to "Yes" so that you can only add new record and not even show all previous records.

These sound like good solutions, my problem now is that I am not a windows and access user at home, (I use Ubuntu and OpenOffice, sorry don't mean to swear here) I will get back to my work on Saturday night and will give this a try.

Thank you Marianne
Ron

Thank you Marianne,

No, I do not know how to code, but you sure hinted me in two good directions:

1 I typed in your line of code:

docmd.GoToRecord,,acNewRec

as you wrote it, in the Form>Event>On_Load section. That didn't work, and
probably because yours truly placed the code where it does not belong. A message
saying that Macro 'docmd' did not exist made me check out the Macro section of
Access where I created a new Macro (I think..) using the drop down boxes:

under 'Action' I chose 'GoToRecord'
Object type: Form
Object Name: frmMyFormName
Record : New
Offset : (left blank, and not a clue what it is anyway)

saved the macro as 'docmd' and under the Form's properties in the
Form>Event>On_Load section I just typed 'docmd'

Ran it and it works!

2 changing DATA ENTRY to "yes" on the DATA tab on another form with the same
problem did the same trick, as you said in your second suggestion.

thanks again.
Ron