Frank, my first response works if you are opening the orders form to add a new order, however if your trying to open the orders form with pre-existing records try changing your code to the following
Private Sub Orders_Click()
DoCmd.OpenForm "orders", , , "[customerID] =...
Open your form:
Private Sub Orders_Click()
DoCmd.OpenForm "orders"
End Sub
Then place the following code in the orders form:
Private Sub Form_Load()
ordercustomerid.Value = Forms!Customer!customerid
End Sub
*substitute the name of your field from the orders table
with...
Try PC Inspector File Recovery ... Not only is it free but it dose a wonderful job of recovering lost or deleted files...
www.pcinspector.de
*note* after running PC Inspector go to file : Find and type in *.mdb as a wildcard to locate the deleted database files instead of going through...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.