help with the AddFromOutLook Macro

[vanlanjl]

Okay quick question -
I have a form that shows user information
I have a cmdbutton called "cmdAddFromOutlook"
it has the following macro for 'On Click'

RunMacro       AddFromMacro
GoToRecord    ,,GoTo,
 

AddFromMacro:

OError                            Next,
RunCommand                 AddFromOutlook 
SetDisplayedCategories   Yes,acNavigationCategoryTabelsandVeiws   
 

So this is what happen: you click the add from outlook button and it open the search from outllook and you look for a user and click add then enter and then it goes back to the access form but now instead of the form being blank (new record) it is now set to the first record (text boxes have 1st record info in them)
That is my problem

Now I also have a combobox that shows user names and runs the following

Private Sub Combo42_GotFocus()
Combo42.Requery
End Sub
 

This refreshes the list and the new user is now in the list and you click on them and there information will populate allthe text boxes on the form.

What I wan tto know is there a way that after you select the user from the outlook search that their info will populate the textboxes instead of going to the first record?
Thanks
(hope this makes sense, hard to explain)

[maxamis4]

So you want to pull data from the Outlook Address book? If so why don't you just link out look to access and use the outlook data?

you can link directly. File -> Get External Data -> Link -> Outlook ->
Address book.

[vanlanjl]

Missing the point. I am already linked by using the addfromoutlook macro that is built in to access. That is not the problem posted

[maxamis4]

So what you are saying is that you want to search within Outlook and return the value you searched for correct?

Take a look at this link http://bytes.com/topic/access/answer...-records-form1. Its not your exact problem but its around a simlar line.

Unfortunately my Outlook in Access is expierence is limited.

[vanlanjl]

uhh... thats my thread

[DonRayner]

Your new record should be the last one in the recordset. So when you go back to your form, requery it and then go to the last record.