2 questions

[antonov]

I have 2 problems:
1. I don't know why the command sendkeys "~" won't work on my pc but it
works on any other pc I run the program on
2. I have this form in which I input some data. If the data is not in the
table then a new form will open and I can input the new data. When I'm done
I press the "done" command button which runs this code:

DoCmd.Close acForm, "Warehouse"

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Warehouse"

stLinkCriteria = "[IdMAWB]=" & [whatmawb]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Now: this works fine but... is there another way to make "Warehouse" refresh
without closing and reopening it?

Thanks for any input

 

[Guest]

Hi

Don't know why the ~ does not work as not enough information.

You can use Me.Requery for the OnClick event of your Done button.

Private Sub Done_Click()
DoCmd.Requery ""
End Sub


Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.