Hi,
I have a form(to add clients) which call 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 --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> 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/
