Hello,
I have a form for adding/viewing employee records. I can open the form,
view records and using the navigation button, add a new record just fine.
However, I'd like to open the form using a command button so that all fields
are blank and a new record can immediately been added without having to use
the navigation button. Can anyone help me figure out how to do this?
TIA,
Rich
|
|
0
|
|
|
|
Reply
|
 Utf
|
11/13/2007 9:20:02 PM |
|
On Tue, 13 Nov 2007 13:20:02 -0800, rich wrote:
> Hello,
>
> I have a form for adding/viewing employee records. I can open the form,
> view records and using the navigation button, add a new record just fine.
> However, I'd like to open the form using a command button so that all fields
> are blank and a new record can immediately been added without having to use
> the navigation button. Can anyone help me figure out how to do this?
>
> TIA,
> Rich
Code the command button's Click event:
DoCmd.OpenForm "FormName", , , , acFormAdd
Change "FormName" to whatever the actual name of the form to be opened
is.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
|
|
|
1
|
|
|
|
Reply
|
fredg
|
11/13/2007 9:30:08 PM
|
|
You could open the form in data-entry mode.
--
Maurice Ausum
"rich" wrote:
> Hello,
>
> I have a form for adding/viewing employee records. I can open the form,
> view records and using the navigation button, add a new record just fine.
> However, I'd like to open the form using a command button so that all fields
> are blank and a new record can immediately been added without having to use
> the navigation button. Can anyone help me figure out how to do this?
>
> TIA,
> Rich
|
|
|
0
|
|
|
|
Reply
|
Utf
|
11/13/2007 9:34:00 PM
|
|
Perfect!!!
Thanks Fred!!!
"fredg" wrote:
> On Tue, 13 Nov 2007 13:20:02 -0800, rich wrote:
>
> > Hello,
> >
> > I have a form for adding/viewing employee records. I can open the form,
> > view records and using the navigation button, add a new record just fine.
> > However, I'd like to open the form using a command button so that all fields
> > are blank and a new record can immediately been added without having to use
> > the navigation button. Can anyone help me figure out how to do this?
> >
> > TIA,
> > Rich
>
> Code the command button's Click event:
> DoCmd.OpenForm "FormName", , , , acFormAdd
>
> Change "FormName" to whatever the actual name of the form to be opened
> is.
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
11/14/2007 2:20:04 PM
|
|
|
3 Replies
1205 Views
(page loaded in 8.122 seconds)
Similiar Articles: How to open a blank form for adding a new record - microsoft ...Hello, I have a form for adding/viewing employee records. I can open the form, view records and using the navigation button, add a new record just ... View all records but start with blank record - microsoft.public ...How to open a blank form for adding a new record - microsoft ... How to open a blank form for adding a new record - microsoft ... How to open a blank form for adding a new ... Open form for add/edit records - microsoft.public.access.forms ...How to open a blank form for adding a new record - microsoft ... Adding Records To add a new blank record. From the View menu ... An open table. Having a blank, new record for entry when you open a form ...How to open a blank form for adding a new record - microsoft ... I have tried adding to the 'open form' macro on the ... Having a blank, new record for entry when you open ... how to hide the last blank record in form - microsoft.public ...How to open a blank form for adding a new record - microsoft ... open continuous form - shows 1st record not last.. - microsoft ... Open form for add/edit ... form for ... opening forms to a blank record in Access 97 - microsoft.public ...How to open a blank form for adding a new record - microsoft ... opening forms to a blank record in Access 97 - microsoft.public ... How to open a blank form for adding a ... How To Have A Form Start With A Blank? - microsoft.public.access ...How to open a blank form for adding a new record - microsoft ... Hello, I have a form for adding/viewing employee records. I can open the form ... blank, new record for ... New (Blank) record not active - microsoft.public.access.forms ...How to open a blank form for adding a new record - microsoft ... New (Blank) record not active - microsoft.public.access.forms ..... record' button not active in Access ... Open Form with macro and data from Selected Record - microsoft ...How to open a blank form for adding a new record - microsoft ... Open Form with macro and data from Selected Record - microsoft ... Report as ... I have tried adding to ... Open form to ID and add in the record if not there - microsoft ...... acDataErrAdded the Data<ode argument open the form with only a new, blank record. ... Is there a ... 2007 - force form to open with new record ... open form/add new ... How to open a blank form for adding a new record - microsoft ...Hello, I have a form for adding/viewing employee records. I can open the form, view records and using the navigation button, add a new record just ... ???open forms to a blank record??? [Archive] - Access World ForumsNow go into your VBA code and in your Sub Form_Load() add the following statement: DoCmd.GoToRecord , , acNewRec This will open your form to a new/blank record. Open Form to Add New Record is Blank - Wrox Programmer ForumsHi, I am helping someone in remote location install and use an Access Application I wrote for him. When he click a button to open a form and add a new Using MS Access: Open form to new record, previous records, access ...I am trying to set forms so that when they are opened, they are opened to the newest record (the blank 1) that can ... set the the code that opens the new form to open in Add ... Adding RecordsTo add a new blank record. From the View menu ... An open table. An existing record. The name of the field ... to use a form to edit a record, create a text box in your form ... 7/21/2012 5:56:39 AM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
31 followers. 