Option Page on a Form

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

Guest

I have a quote form that I've created for entries, is there a way that when I
open this form that the FIRST page would give me the option of whether I want
to Add a New Quote or Edit a Quote and when the command button is selected it
would direct me to the appropriate form?

Please advise.

FYI, I'm not an expert so any help would help.

Thanks Bunches!!!
 
Crystal T said:
I have a quote form that I've created for entries, is there a way that when
I
open this form that the FIRST page would give me the option of whether I
want
to Add a New Quote or Edit a Quote and when the command button is selected
it
would direct me to the appropriate form?

Please advise.

FYI, I'm not an expert so any help would help.

Thanks Bunches!!!
Click to expand...

You'll need a second form with two command buttons. In the Click events of
the buttons, open the quote form as appropriate with the DoCmd.OpenForm
method. To add a new entry, you could open the form like:

DoCmd.OpenForm "quote form name",,,,acFormAdd

This will position you to a new (blank) record for entry. To open the form
for editing, omit the acFormAdd parameter:

DoCmd.OpenForm "quote form name",,,,acFormAdd

This will open the form with the normal recordset loaded, and you can scroll
through the records.

Carl Rapson
 
Back
Top