How do I direct someone to a new record

G

Guest

I have a well developed databased we use for Engineering change control. We
use a switchboard to navagate entry personnel to the data entry forms or
table views. The problem were incountering is that when some of the entry
personnel to the entry form to enter a new record they don't acknowledge that
the form is displaying data from record 001 and that they need to index to a
new record. I know, sound like this should be a simple training issues for
our Darwin candidates, but...

Is there a way to set of the input form so that it comes up automatically in
a new record instead on on record 001? Or should I develop another entry
form that somehow pulls up a new record only and add that to the switchboard?
I can provide a beta copy of the database if someone can help me figure this
out.
 
G

Guest

Open the form in design view
Right click the form (not the detail)
Open properties box
Select event column
Select OnLoad
Select build option (...)
Select code
Insert this

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub

Save and close

Hope this helps
 
G

Guest

I see where your going with this but unfortunately i do not have the "Onload"
option listed in the Even Column (tab).

What I have in my 2002 SP2 version is:
On Click...
On Dbl Click...
On Mouse Click...
On Mouse Move...
On Mouse Up...

Any suggestions?
 
G

Guest

Nevermind. Your instructions were perfect. I simply had my own Darwin
episode. I was in the detail and did not realize it. Worked perfectly.
Thanks a million.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top