BrowseTo or GotoControl msaccess 2010

[savvas]

Testing msaccess 2010

Hi everyone I am stuck with this problem for a long time.
So I decided to upload searching for some ideas.

I have made two forms a stand alone Client form and a Navigation form where inside there is the Client form.
Another form finds Clients by criteria...... What I wan't to do is open the
Navigation form, goto the Client form and at a specific record.

I can easy go from the find form to the stand alone client form. (as you can see in the example)

This is my problem... I wan't to go from the find form to the client form INSIDE the Navigation form (MENU). Offcourse trying this method I have changed the search creteria inside the query.

I have tried the BrowseTo and the GotoControl command. with no success. I've used the GotoControl in several databases and know how it works when jumping between forms, subforms, etc.
I used the BrowseTo command in a web based database and it also works correct. But at this example I wan't to go to a form and not to a datasheet.

I think that the problem is that the Navigation form is not a Web Navigation Form and the BrowseTo command does not support it because the second pair of form and subform is missing.

thanx

 

[dkinley]

Only running 2008 here, but making a guess (couldn't open your db).

I am supposing you have one form that does the searching and then you are opening up records in a seperate form? If so, here is something that works in 2008 ...

The setup here is that the search form is a filtered recordset, and the form you want to show the record is already open like in a split screen scenario (if not, then you will need to put in the code to open the form) ....

    Dim rsShowRecord As Recordset
    Dim lBookmark As Long
 
    'set variable to current record
    lBookmark = Me.pkRecordID
 
    'set the focus on the other form
    Forms("fOpenFormToShowRecord").SetFocus
 
    'send ID to open form
    Set rsShowRecord= Forms("fOpenFormToShowRecord").RecordsetClone
    rsShowRecord.FindFirst "pkRecordID= " & lBookmark
    Forms("fOpenFormToShowRecord").Bookmark = rsShowRecord.Bookmark
 
    rsShowRecord.Close
    Set rsShowRecord = Nothing

HTH,
-dK

 

[SOS]

Only running 2008 here, but making a guess (couldn't open your db).

Are you sure you don't mean 2007?

 

[dkinley]

Hahahaha ... yeppers!

 

[SOS]

Hahahaha ... yeppers!

I was wondering if you had a special, Bill Gates Only, version.

 

[dkinley]

I don't know him ... personally ... yet.

-dK

 

[savvas]

Hi again

This is a beta version of access 2010
That is why I begin with "Testing msaccess 2010".

One of the new things in 2010 is Navigation Forms.

Anyway thanx for the replies.

 

[dkinley]

Ah ... too much in '07 for me to go about trying to learn a whole new one. Besides, convincing IT departments to go to '10 (and companies to purchase) until there is a 6 months gestation on the first SP would be too big of a bull for me to wrestle.

I know the ones I work with just went to Office '07 less than a year ago.

-dK