open form based on combobox

please, I have two forms "form1" and "form2", on form one I have cascading combobox called "cbo27", what I am trying to do is after update of "cbo27" than this will open form2 and place the contents of "cbo27" into a textbox called "isodwgno

Sponsored Links:

Related Topics

Open form to specific record based on combobox
Here is what I want to do.have a combobox that only displays records on a table where field = 0. got that.now I want to be able to click on record in combobox and have it open up the form to that specific record.

So far I have combobox with.

SELECT tblLoad.LoadID, tblLoad.LoadDate, tblLoad.AutoclaveID, tblLoad.LoadNumber, tblLoad.[Cycle Complete] FROM tblLoad WHERE (((tblLoad.[Cycle Complete])=0));

Bound Column is 1

This works to limit records shown in combbox.yea!
Now I can't figure out how to open form to that particular record.have tried several things in afterupdate of combobox.but no luck


updating a control
I have a form which has a combobox. Next to the combo is a button. when the button is hit it will open another form for data entry.

if the combobox is empty, then the button will open a form and start a new record

if the combobox has a value in it, then the button will open a form to the correct record (corrosponding to the combobox value)

the form that the button opens modifies the table that the combobox data
is picked from.

all of this works as expected. now for the question :

when the user returns to the original form, how do I get the combobox to 'update' the available values from the table that the other form just modified? ( I prefer to not do this as I close the other form, but rather put some code in to update the combobox when the original form regains focus ) for example, if the user creates a new record, and then closes the form, the combobox does not have the new record as a choice.

something like

on event gainfocus : me.mycombobox.rebuild your list


forced position of combobox
I have a form frmUnits working well with a combobox based on MyID. When I open frmUnits by a macro from another form frm2 where I have a field Textbox10 with let´s say having value 45 and in a macro says "Open frmUnit where MyID = the value in Textbox 10 in frm2 this will go OK. The frmUnit then shows me the post with MyID = 45.

But then I can't use my combobox for changing to onother post in frmUnit because the frmUnit is locked to just MyID = 45 even if I can change the value in my combobox.

How to release the frmUnit combobox not changing the one and only MyID = 45 showed post ?


Query based on ComboBox selection
I'm trying to create a query that will run based on what is selected in the combobox. I have a main form which holds the subform with the combobox. I want a button to open the query. Thequery field references the combobox with [forms]![subFrmName]![cboName].

My problem with this comes when I press the button and I get a message box titled "Enter Parameter Value" with my field reference line Forms!subFrmName!cboName with a text box underneath.

I've checked the subform name and combobox name multiple times and it appears that I'm referencing them correctly.


Query based on ComboBox selection
I'm trying to create a query that will run based on what is selected in the combobox. I have a main form which holds the subform with the combobox. I want a button to open the query. The query field references the combobox with [forms]![subFrmName]![cboName].

My problem with this comes when I press the button and I get a message box titled "Enter Parameter Value" with my field reference line Forms!subFrmName!cboName with a text box underneath.

Am I doing something wrong? I've checked the subform name and combobox name multiple times and it appears that I'm referencing them correctly.


ComboBox not listing multiple columns
I have a combo box based off a query. I want to add a second column to the combobox, so I went and added the field that I want added to the query that the combobox is based on. But when I went to go create a new ComboBox, it is not showing all the fields from the query it is based on! Why is this?


Three Comboboxes Synchronized
Have three comboboxes in "ProductRegister" form
1) Products Category
2) Products
3) Packing

1. Select the category from the first combobox,
If the category is not available update the category table by enterting the category in the combobox

2. Based on the selection of the category combobox the products will be displayed in the products combobox.
Again if the product is not available update the products table

3. Based on the products combobox the packing will be displayed in the third combobox.

I was able to get the data in the second combobox based on the selection in the first combobox. But not going to the third one. Also to add a new item if not available.


Filter on Load Report Based on A Form ComboBox
Form Name: popup; Combo1 is the name of the Combobox I want to pass information to my report on load to filter the report output. Query report is based on: Open Issues. Report Name: Active Issues by Physician (field I want to filter is Provider Name)

I have the form built and here is the code behind the cmd button set OnClick:


Combobox showing ID, can't find fix
I have 2 forms under a heading of System Edits. Create New Record and Verify Open Records.

They are used for tracking any system changes. I create a new record and have a combobox to select which user made the change. The form contains an editable side for new record entry and a locked side to show the verify info.
This updates the tbl_systemEdits.

I have a query based on this table that only shows if a verified date is null. The Verify Open Records is based on this query so that a different user can verify the edits. I have a combobox on the verify section to select a user, which should populate back to the New Record form but all I can get it to list is the Record ID, not the user name


populate a combobox based on a textbox in a form
I have seen combobox based on combobox and textbox based on combobox, but I need a combobox to populate from a textbox. In my example I have a number of sales orders and each sales order has multiple unique serial numbers attached to it.

So I want to be able to type in a sales order number on a form and have it populate a combobox on that form with the serial numbers attached toit.


Filter subForm comboBox based on main form combobox selection - SAMPLE ATTACHED
Here is my problem. I am trying to filter a combobox on a subform based on a combobox on my main form. I am successfully able to do this with two combo boxes on the same mainform but not with one on the mainform and one on the subform. I have attached a sample database with the tables, queries, and forms associated with this issue.

I have read numerous topics on this site relating to this topic and I have tried all the responses but I just keeping getting lost in the middle of the


Opening form based on specific record only when combobox option is selected?
I have a database for tracking patients that could have many diagnoses, all of different types. I want the user to select a diagnosis from a combobox and then a form automatically opens where you can add details specific to that diagnosis. So for each separate diagnosis option, I need a different form to open.

I know how to open a form to a specific record with the button wizard and I know how to write code that opens a specific form depending on which option is selected, but I don't know how to use them together.

then I don't need to use them together since I don't need to pull up a specific record, but I want the user to be able to double click any diagnosis that has already been entered, which will then pull up the corresponding form with that record so they can see the details of it.

So how can I put code in the double click event of the combobox that basically says if the option selected is this, then open this form, if the option selected is that, then open that form, etc. and ALSO open the form to the corresponding record?


Three Comboboxes
I am in the process of creating a register database.

Have three comboboxes
1) Products Category
2) Products
3) Packing

1. Select the category from the first combobox,
If the category is not available update the category table by enterting the category in the combobox

2. Based on the selection of the category combobox the products will be displayed in the products combobox.
Again if the product is not available update the products table

3. Based on the products combobox the packing will be displayed in the third combobox.

I was able to get the data in the second combobox based on the selection in the first combobox. But not going to the third one. Also to add a new item if not available.


Select Subform from Combobox
New to all this so probably a dumb question but can I have a combobox selection to open a specific subform in a form. In Quickbooks, you open an invoice form which has one combobox to select Customer and one to select Template. I am trying to create something similar, a form that selects the customer details then another combo opens differently designed "tests sheet" subforms in that main form. I could be on the wrong track so thought I'd ask?


Combobox Selection To Run Query
I have a form that will show static data in textboxes that are in the form detail and form header based on the selection of a job number in a combobox that is in the form footer.

The data has to come from 2 different tables. I assume I have to create a query based on the data I want from each table. How do I link the combobox selection to the query criteria: so thatit only returns the data for that job number and once that is done how do I get it to display in the form textboxes.I know how to get the combobox to populate the textboxes with data fromone table.


Combobox:Web DB, Select values from combobox and store in a table
I have a web database, with a form that submits data to a table (table1). I also have another simple table (tableForCombo) that contains names, which are being shawn in a combobox.

I want the user to
open the form,
pick a value from that combobox and
store it in another table.


Query based on Value in a Combobox
I have a form InvInputfrm that has a combo62. When I select the value in that combobox I want it to be the parameter for my select query. This result will then populate combo64 of the InvInputfrm. Then based on the selection of combo64 a textbox will be filled in with data from column (1) of that combobox.


Display image based on combobox selection?
Is it possible to have an image be displayed based upon a combobox selection?

I'd like to have a vendors logo be displayed on the form if their name is selected in a combobox


ComboBox - Open Form Based on Table Column Data
I have created a SwitchBoard in Access 2010(I know about Navigation - do not like it), and on it I have a combo box. The combo box is pulling data from a lookup table that has two columns:

Column 1 - Friendly Form Name
Column 2 - Actual Form Name

As an example, I have a form named frmEquipLoTch. I know exactly what this is; however, if my users saw it, they would not. So, the record for this form would be:

Column 1: frmEquipLoTch
Column 2: Tech Equipment

Here is what I want to happen:
The user picks the form name to jump to. The combo box will only display the Friendly Name (I know how to do this).
Then, with the proper report displayed in the combo box, they will click a button that says "Go" and I am assuming I will need to use VBA to get the value of the combo box and open the corresponding form. Now, I know how to open a form with script, no problem. But what I would like to know is how to read the corresponding actual form name from the combobox and use that as the variable in the code.

I hope that makes sense. Now that I wrote it out, it sounds confusing. I know that I could just hard code something like:

If comboBox.Value = "Tech Equipment" Then
DoCmd.openForm frmEquipLoTch, acViewPreview
End If

However, this is not as extensible as I would like for obvious reasons.


choosing combobox option to open different form
if I want to make a combobox
Type of calling : Personal, Question, Problem
I put them in a combobox whith a button GO

I want to open form 1 when I click Personal
Form 2 when I click Question
Form 3 when I click Problem