Dropdown list to open Form help!

[Bob]

I have created a dropdown combo list box (cbOwnerMain) now I want it to open
the owners record form when I click on his name, the form name that the
owners appear on is (FrmOwnerInfo) and the Query is (qryOwnerInfo), I
suppose something on click event!

Thanks in advance.........Bob Vance

 

[Tom Wickerath]

Hi Bob,

It sounds like you are going to want to add code to the AfterUpdate event
procedure for your combo box that includes using the Docmd.Openform method,
and passing the optional WhereCondition argument. The argument passed is
likely going to be the primary key value of the owner whose record you wish
to open up. Is this value currently available in the row source of your combo
box?


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________