473,385 Members | 1,806 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Command button to start new record in specific form

emandel
65
I am an armature access programmer trying my best to design my own database so your patience and detailed instructions is much appreciated.

Here is my question:
How do I get a command button (on form 'a') to not only open a specific form (form 'b') (which I can do with the wizard) but to open that new form to a blank new entry?
Jan 1 '07 #1
3 7829
MMcCarthy
14,534 Expert Mod 8TB
I am an armature access programmer trying my best to design my own database so your patience and detailed instructions is much appreciated.

Here is my question:
How do I get a command button (on form 'a') to not only open a specific form (form 'b') (which I can do with the wizard) but to open that new form to a blank new entry?
In the properties of form 'b' you can set the Data Entry Property to yes if you only ever use that form to enter new records.

Otherwise, you can change the form open code as follows:

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "form 'b' name", acNormal, , , acFormAdd
  2.  
Mary
Jan 1 '07 #2
emandel
65
Thank you that was helpful
Jan 1 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
Thank you that was helpful
You're welcome.

Happy New Year!

Mary
Jan 1 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

14
by: Kevin | last post by:
A couple of easy questions here hopefully. I've been working on two different database projects which make use of multiple forms. 1. Where's the best/recommended placement for command buttons...
1
by: AA Arens | last post by:
I my form I have put record navigation buttons. When I choose just before the last record, the "Go to next record" button, access automatically start with a new record instead of a message that...
4
by: John Smith | last post by:
I have a continuous form. there is a command button with the following code for the OnClick event: DoCmd.OpenForm "frmPlants", , , "PlantsID =" & Me!PlantsID I click the button and frmPlants...
0
by: jpr | last post by:
Hello, I use a listbox and a command button on a form as criteria to open another form. The click event of my cmdbutton has the following code that runs after selecting a record in the...
3
by: kev | last post by:
Hi folks, I have a form for registration (frmRegistration) whereby i have two buttons. One is Save which saves record using the OnClick property. I used wizard to create the save button. The...
3
by: Imicola | last post by:
Hi, I have seen very similar questions which have not really helped me, so thought I'd better ask for some more help. I have a form called fsubAnimalDetails(which holds data on animals...
7
by: pukhton | last post by:
I have a command button on my form, and would like to ask my user if they really want to delete the specific record. I have figure that out, no problem. The problem I am having is when they click on...
1
by: CoolFactor | last post by:
MY CODE IS NEAR THE BOTTOM I want to export this Access query into Excel using a command button on an Access form in the following way I describe below. Below you will find the simple query I am...
3
by: getro | last post by:
Hi Everyone, I need to open an Access 2003 form to a specific record from a custom Outlook 2003 Appointment form. The form has a command button that would pass a record id to access and open the...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.