I have a data entry form. One of the fields on the form needs to be selected from a predefined list. I tried using a combobox to provide this but the list is too big.
Instead I created a search form that opens when the user clicks a command button next to the field on the data entry form.
When this new search form opens the user has the ability to search and select the record they want. I need the ID selected to be passed back to the Data Entry form.
I have tried instantiating the search form as an oject using code below that is executed from the Data Entry form.
Dim f As New Form_Search
f.Modal = True
f.Visible = True
If f.SelectedItem > 0 Then
Set f = Nothing
The problem is that this code continues to run after f.visible = true. What I really want is to hold the code until it is hidden so that I reference and use f.selected item.
Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted. Others take a little more time and effort and often providing a sample database is very helpf…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro: