Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to create multiple instances of form depending on selection made
You can use code along these lines: Private mfrmCustomer as Form_frmCustomer Private Sub OpenNewCustomerForm() Set mfrmCustomer = New Form_frmCustomer With mfrmCustomer .RecordSource = "SELECT * FROM MyCustomerTable WHERE (MyID = 1)" .Controls("MyID").Value = Me("MyID").Value .Visible = True...- jatighe
- Post #5
- Forum: Microsoft: Access Forms
-
Why aren't menus used much?
Menus are very powerful tools to use on a form. To program the menus you need to use the CommandBars object - see help for the full object model. Using this object you can capture what option the user has selected and carry out some action. You can also create context sensitive shortcut menus...- jatighe
- Post #2
- Forum: Microsoft: Access Forms
