Opening form to new record 1

[mrfilez]

Hello all,
I am trying to get a form to open to a new record. I would also like for the form to automatically move to a new record when the last field is filled in. All fields will be required. I know that this is done in VB and I am still trying to learn this also. I have books and have been reading these forums and any training info I can find on the net. The problem, I am running out of time to get the database done. I am not being paid for it, but if I can get this database going my boss might actually finally give me a raise and promotion to Supervisor of the Help Desk. I hate to sound so sad and pathetic, but I dont have much choice right now. Any help that anyone can give would be very much appreciated.

Thanks,
Don

 

[ghubbell]

Hi Don!
Let's button this one up!
If you are operating the open form from a command button, in its On Click event in VB:

DoCmd.OpenForm "YourFormNameHere", , , , acFormAdd

**If the form is used soley for adding records set its "Data Entry" property to Yes and it will always open on a new record.

In your last fields After Update event in VB:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.GoToRecord , , acNewRec

I owed you that one! ;-) Gord
ghubbell@total.net

 

[mrfilez]

Hiya Gord!
Do you not ever sleep?? LOL

Nope I still owe you about 10 or so. And the count keeps getting higher.

I have not read anything about the Data Entry anywhere. I do very much appreciate your help, and your advice, and your encouragement.

Thanks,
Don

 

[ghubbell]

Thanks Don, Yup. I fell asleep at my desk today for a good five minutes and was awoken by that noise a stuck key makes. Had to walk around the office with a reverse "QWERTY" imprinted on my forehead... LOL Gord
ghubbell@total.net

 

[mrfilez]

LOL
I know how you feel. I think I have gotten more sleep at work the last couple of days than I have at home. I am in the process of implementing your answers now. I think I have the idea access wrong. I thought that it was basically, if you had data that would be redundant into seperate related tables. I have been studying the way some of the Sample DBs are setup and they all have tables full of redundant data. And this data is pulled from tables that have no redundant data.
It may take me 5 years to grasp the concepts, but I am finally starting to make a little progress on this DB. With the exception of probably rethinking my whole table structure, I think I am starting to get it going a little bit.

Thanks,
Don

 

[ghubbell]

Five years? Dag nab it! Its taken me seven! LOL Sleep well Don. Tomorrows another day. Gord
ghubbell@total.net