Question?

[Rogue Programme]

I have a search screen (frmsearch) which is linked to my main table (tblmain). On the search screen there is a list box which lists all employees. I can scroll up and down the list box or i can use a search facility that i have created which will narrow the list down.

I also have a form (frmemployee) which is also linked to tblmain.
nb as i add a new record here (new employee) it populates the list box on frmsearch.

This is my problem:

When i scroll or search for an employee and i highlight that employee in the list box (in frmsearch) i want to be able to click the command button that will link to frmemployee and open thier record.

Hope this makes sence

Mike

 

[bpaquette]

i don't know that i entirely understand your plight, but here was a similar situation i had awhile back:

i had a list box of all names in a form, and sevveral boxes of data bound to that names record. anyway i wanted to click on a name and load their data into that box, here's the code i came up with , with no small thanks to everyone on this board


Private Sub lstLastname_AfterUpdate()
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone
rs.FindFirst "LASTNAME = '" & lstLastname & "'"
Me.Bookmark = rs.Bookmark

End Sub


that works just fine as long as the listbox is unbound.


hope that helps??

 

[Hayley Baxter]

The example in this thread might be similar to what you're after (using a combo box)

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46460

 

[Rogue Programme]

Hay

Thanks for your reply.....

I had a look at inserting a command button on 'forma' to navigate to a particular record on 'formb' but i can't see where it gives the option to link by ID (I wish it did)!

Any Ideas?

 

[Rogue Programme]

Haley..

Thanks, got it working...i used your command button example via wizard.

How easy was that.

Thanks again

Mike

 

[Hayley Baxter]

No problem...tell me know after I just made you another example

 

[Rogue Programme]

SORRY

Thanks again.

Mike