Forms

[Pass-the-reality]

The properties on my form (frmMain) are set to Data Entry. When I click add
a record from the switchboard, the form (frmMain) opens and then I hit submit
and it closes out. From the form I can not navigate to view other records.
This is how I want the form set up - true data entry style. However, on my
switchboard or another form, can I add a command button that will allow me to
view/edit all of my entries using the same (frmMain). I tried creating a
subform and through the Command Button Wizard linking date fields so that all
the records for a specified date would be viewable. What happens is after
clicking the command button the frmMain opens, but shows a new blank record.
Is there something I need to modify on my form? I have it set to allow
additions.

 

[John W. Vinson]

The properties on my form (frmMain) are set to Data Entry. When I click add
a record from the switchboard, the form (frmMain) opens and then I hit submit
and it closes out. From the form I can not navigate to view other records.
This is how I want the form set up - true data entry style. However, on my
switchboard or another form, can I add a command button that will allow me to
view/edit all of my entries using the same (frmMain). I tried creating a
subform and through the Command Button Wizard linking date fields so that all
the records for a specified date would be viewable. What happens is after
clicking the command button the frmMain opens, but shows a new blank record.
Is there something I need to modify on my form? I have it set to allow
additions.

If the Data Entry property is set, then you will *not* be able to view
existing records (with or without a subform).

I'd suggest having the form set with the data entry property set to No, and
instead pass an argument from the switchboard to set it or not as appropriate:

DoCmd.OpenForm "frmMain", DataMode := acFormAdd

for the data entry option; use acFormEdit or acFormReadOnly as appropriate for
the other option.

 

[172.16.6.47]

The properties on my form (frmMain) are set to Data Entry. When I click
add
a record from the switchboard, the form (frmMain) opens and then I hit
submit
and it closes out. From the form I can not navigate to view other
records.
This is how I want the form set up - true data entry style. However, on
my
switchboard or another form, can I add a command button that will allow me
to
view/edit all of my entries using the same (frmMain). I tried creating a
subform and through the Command Button Wizard linking date fields so that
all
the records for a specified date would be viewable. What happens is after
clicking the command button the frmMain opens, but shows a new blank
record.
Is there something I need to modify on my form? I have it set to allow
additions.

 

[172.16.6.47]

The properties on my form (frmMain) are set to Data Entry. When I click
add
a record from the switchboard, the form (frmMain) opens and then I hit
submit
and it closes out. From the form I can not navigate to view other
records.
This is how I want the form set up - true data entry style. However, on
my
switchboard or another form, can I add a command button that will allow me
to
view/edit all of my entries using the same (frmMain). I tried creating a
subform and through the Command Button Wizard linking date fields so that
all
the records for a specified date would be viewable. What happens is after
clicking the command button the frmMain opens, but shows a new blank
record.
Is there something I need to modify on my form? I have it set to allow
additions.