go to a record in another form from list box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have two tables 'a' and 'b' where some items in 'a' are linked to a record
in 'b', with all linkings shown in a listbox in form 'a'. If there is a link
I would like to be able to select it from the list in 'a' and have form 'b'
open and go to the appropriate record. I can produce the list box no worries,
the rest is a bit over my head! thank you.
 
Ben,
You should be able to open form B using the OpenForm Method. The
OpenForm Method has a "Where" argument that you can use to find the record
listed in your form A listbox.
DoCmd.OpenForm "frmYourFormB", , , "YourBField = " & lstAValue
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Back
Top