By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,488 Members | 2,545 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,488 IT Pros & Developers. It's quick & easy.

Acess/VB Coding

P: n/a
jen
Hello,
I'm just starting to develop an Access database. I have a start form
and the user can click a different button to open different forms. I'm
trying to modify the code so when the user clicks one of the buttons,
it opens a new form, but brings the user to create a new record. Any
help would be appreciated!
Thanks!

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
set the DATA ENTRY property of the form being opened to YES. This way the
form will always open on a new record.

HTH
Paul

"jen" <je*******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hello,
I'm just starting to develop an Access database. I have a start form
and the user can click a different button to open different forms. I'm
trying to modify the code so when the user clicks one of the buttons,
it opens a new form, but brings the user to create a new record. Any
help would be appreciated!
Thanks!

Nov 13 '05 #2

P: n/a
Paul & Jen,
I remember in Access 97 I had recordset clone navigation methods that let me
move to the first, next, previous, last & new record. I can't find them in
subsequent versions of Access that use ADODB. If you tie your application
to Jet/DAO then I'd guess the navigation methods I was used to would be
there.
"Paul" <pz****@rogers.com> wrote in message
news:Mu********************@rogers.com...
set the DATA ENTRY property of the form being opened to YES. This way the
form will always open on a new record.

HTH
Paul

"jen" <je*******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hello,
I'm just starting to develop an Access database. I have a start form
and the user can click a different button to open different forms. I'm
trying to modify the code so when the user clicks one of the buttons,
it opens a new form, but brings the user to create a new record. Any
help would be appreciated!
Thanks!


Nov 13 '05 #3

P: n/a
jen wrote:
Hello,
I'm just starting to develop an Access database. I have a start form
and the user can click a different button to open different forms. I'm
trying to modify the code so when the user clicks one of the buttons,
it opens a new form, but brings the user to create a new record. Any
help would be appreciated!
Thanks!


Docmd.OpenForm has an argument DataMode which you can set to acFormAdd

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #4

P: n/a

"jen" <je*******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hello,
I'm just starting to develop an Access database. I have a start form
and the user can click a different button to open different forms. I'm
trying to modify the code so when the user clicks one of the buttons,
it opens a new form, but brings the user to create a new record. Any
help would be appreciated!
Thanks!

Display the form. Under "View" click on "Design". Under "View" again click
on "Code". Look for something like "command1_click().
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.