Open form from Listbox - not record but form for data entry (1 Viewer)

[inkbird01]

Hi,

I have a list box that is used for navigation. If the user clicks on a list box item (row) then open the from with that name. I have a table tbl_controls that haves [ID].[Form Name].

I.e on click, lookat column o of the listbox and open the form that match the ID in the table

What is the best way to do this?

thanks

 

[isladogs]

In the listbox Click or AfterUpdate event, use the code:
DoCmd.OpenForm Me.YourListboxName.

You can see a more complex version of this in my example app

View Database Objects & Metadata

This article includes an example app used to view all objects in a database together with their properties and metadata.

www.isladogs.co.uk