Help with Forms!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a database by using the Switchboard Manager. On my main menu
screen, I have a button called "Modify Information" and another one called
"Input New Information." I have a two questions that relate to how the forms
will be used.

1). When the user clicks on "Input New Information", the form "S.
Information" is opened. Is it possible that the last record is automatically
displayed? What I really want is to have the text boxes/combo boxes empty so
the user can input the information. Right now, when you click on "Input New
Information" button, the "S. Information" form opens however the first record
is automatically display and you have to use the navigation buttons to get to
the last record (an empy record).

2) When the user clicks on "Modify Information" button from the switchboard
menu, the "S.Information" form is also opened. Is it possible to place
constraints on the form only when this button is clicked? The constraints
that I want are to prevent the user from entering new information and just
updating the information that is displayed by the form?
 
To get a new record to be displayed you will need to change the VBA code
just a bit. You should have something like this in the subroutine for your
button:
stDocName = "Form_Name"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Maximize

After all of this add the following line:

DoCmd.GoToRecord , , acNewRec

This should take you to a blank record each time you click on the button.


As far as the contraints on the form go, I the easiest way to do this is to
have the button call up a form with the contraints already in place. These
constraints are in the properties list in the form design view.

Hope this helps.

Nick M
 
Back
Top