Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADP FORM - Add new record

Status
Not open for further replies.

mapfax

Technical User
Apr 23, 2002
29
0
0
GB
Hello,

Can't seem to understand what is wrong here. Within an Access Project connecting SQL 7.0, I have a search form for customers and a main form for displaying the customer details. For existing customers there is no problem except for a new customer I can't get

>DoCmd.OpenForm stDocName, , , , acFormAdd, , Me!_[CustomerID]

OR

>DoCmd.GoToRecord , , acNewRec

to work properly. It only works if the form is *not* already open. If it is already open then I end up overwriting the currently displayed customer details. Is there something I am missing here (apart from closing the main form)?

Thanks, Mark.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top