Talk About Network

Google





Software > Access Forms > Re: Using Wizar...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 3 Topic 44640 of 46786
Post > Topic >>

Re: Using Wizard to open form and go to record

by =?Utf-8?B?Tmlja1c=?= <NickW@[EMAIL PROTECTED] > Aug 13, 2008 at 06:07 AM

....  That seems to be a lot more complex than in 2003.  Why doesn't the 
wizard work?

"Damon Heron" wrote:

> You will have to go to the VB Code and add the stLinkCriteria manually:
> Dim stDocName As String
> Dim stLinkCriteria As String
> 
>     stLinkCriteria = "YourRecordID = " & Me.Textbox1
>     stDocName = "YourFormName"
>     DoCmd.OpenForm stDocName, , , stLinkCriteria
> 
> where textbox1 contains the ID of the record you want to go to when
opening 
> the new form.  If you want to use a string field, then
> you will have to modify the code slightly -- "YourRecordString = " & "'"
& 
> me.Textbox1 & "'".
> 
> Damon
> 
> "NickW" <NickW@[EMAIL PROTECTED]
> wrote in message 
> news:63AEC529-6F3B-4FD0-B2C5-15E6A0940C0C@[EMAIL PROTECTED]
> >I would like to create a sort of switch that has "search" boxes
(unbound 
> >text
> > fields).  In 2003, one could create a form with unbound text fields
and 
> > use
> > the Command Button Wizard to open a form and go to a specific record. 
I 
> > get
> > to that point in 2007, but then it gets weird.  The wizard asks to
match 
> > up
> > fields on the current form and the one you want to open.  But, on the 
> > current
> > form side, there are no text fields to match it up with.  Is there a
fix 
> > for
> > this? 
> 
> 
>
 




 3 Posts in Topic:
Using Wizard to open form and go to record
=?Utf-8?B?Tmlja1c=?= <  2008-08-06 15:33:01 
Re: Using Wizard to open form and go to record
"Damon Heron" &  2008-08-07 08:24:39 
Re: Using Wizard to open form and go to record
=?Utf-8?B?Tmlja1c=?= <  2008-08-13 06:07:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Fri Jan 9 12:40:45 PST 2009.