Hi, I have a form(to add clients) which calls another form in Dialog mode (to check client). The Dialog form uses a listbox, if a record is chosen from the list box a button opens a third form(to update the client). What I'd like to do is not save any data on the First form(add clients), close it and open the third form to update. Here is what I'm using: Dim stDocName As String Dim stLinkCriteria As String
stDocName = "frmMHUpdateClientEntry" ->DoCmd.Close acForm, "frmmhcliententry", acSaveNo (this line gets "This action can't be carried out while processing..) stLinkCriteria = "[ClientID]=" & Me![List0] DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.Close acForm, "frmchkclientexists", acSaveYes Any advice would be great!! Thanks in advance Joe ------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/.QUssC/izNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
