Open new forms

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have a button on my form that will open another form
when clicked and find a specific record to display. For
some reason when you first click the button (when the new
form is closed) it will open the new form and display
first record. If you click the button again, when the new
form is opened, it will find the correct record to
display. What is making it not find the correct record on
the first click. I just used the wizard to generate the
code which follows:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Collections Letter #3"

stLinkCriteria = "[Member Number]=" & Me![Member
Number]
DoCmd.OpenForm stDocName, , , stLinkCriteria
 
I don't know if this will make a difference but you could try giving your
form another name, one without the #, since this is used to identify a date.

Do you have any code in the form you are opening eg to requery it?

Evi
 
Back
Top