Option Page on Form

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

Guest

I have a form that I created that allows me to enter new quotes. Is there a
way I can set up something that when I open this form a page would come up
and give me the option of "New Quote" or "Edit Existing Quote", and when I
select the appropriate command it would take me to that form?

I'm pretty new at this and any help would be great!!!

Thanks Bunches!!!
 
Crystal T said:
I have a form that I created that allows me to enter new quotes. Is there
a
way I can set up something that when I open this form a page would come up
and give me the option of "New Quote" or "Edit Existing Quote", and when I
select the appropriate command it would take me to that form?

I'm pretty new at this and any help would be great!!!

Thanks Bunches!!!
Click to expand...
 
Go to the code where you open your quotes form. Change your code to look
like this:
Dim MsgStr As String
Dim TitleStr As String
MsgStr = "Click Yes To Enter New Quote" & vbCrLf & vbCrLf _
& "Click No To Edit An Existing Quote"
TitleStr = "Do You Want To Enter A New Quote?"
DoCmd.OpenForm "NameOfQuoteForm"
If MsgBox(MsgStr, vbYesNo, TitleStr) = vbYes Then
DoCmd.GoToRecord , , acNewRec
End If
 
I'm sorry but I'm sort of new at this so your code below is foreign to
me...lol. Is there an easier way to elaborate this without getting too
technical? If not thanks anyways.
 
How do you open your quote form? Can you post the code that opens your quote
form? What is the name of your quote form?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
uugghhh nevermind your first response was great. I just had to use my brain
a bit.

Thanks Bunches!!!
 
Back
Top