Forms :: Cascading Combo Box On A Shared Subform

May 30, 2013

I have a subform that I use on two parent forms. The subform has a cascading combo box. The LocationID field gets filtered after CompanyID (named: cboCompanies) is updated. The problem is that I can only get the combo box to work on one form (Contacts_All). When I open the second form (Contacts_Clients), it asks for the Parameter Value.I am entering this into the criteria for the LocationID field:

[Forms]![Contacts_All]![SUBFRMContactsCompanies]![cboCompanies] Or [Forms]![Contacts_Clients]![SUBFRMContactsCompanies]![cboCompanies]

So, the "Or" is not working.Do I need to make a separate subform for each parent form or is there some way to get this working? I already feel as if I am managing way too many forms and need to simplify.

View Replies


ADVERTISEMENT

Forms :: Cascading Combo Boxes In A Subform

Jan 28, 2014

i have a main form which allows me to fill in Order Information within which is a subform which allows me to fill in Order Lines.My Order Lines contain the following fields:

Extrusion
Length
Qty
etc. etc.

Elswhere in my database (tblLengths) I have set up a list of possible lengths for each Extrusion and therefore when an order is filled out I want the user to be restricted only to those lengths that are possible with the particular extrusion they have chosen. This list contains the ExtrusionID and LengthID so that I can query the available lengths for a particular Extrusion.Within my subform I have set the record source to point at the tblLengths and criteria on the ExtrusionID to point to [Extrusion]. I've also put a requery against the Extrusion field so that I can force the combobox to refresh its list of results.

My problem is that I am getting unexpected results each time I add an Order line into my form and reading up I see that what I am trying to do is a big no-no.

View 12 Replies View Related

Forms :: Cascading Combo Box In Same Datasheet View / Subform

Oct 10, 2014

Is there anyway that we can do cascading combobox in the same datasheet view of subform? Basically I'd like to filter "Account Name" based on "Plan#" selected in the same record of subform.

View 3 Replies View Related

Forms :: Cascading Combo Boxes Not Working In Subform

Nov 28, 2014

I have a cascading combo box working fabulously in a form. However when I embed that form into another form, the cascading combo boxes quit working. After doing some searching around on the web I think my issue is either in the query that the dependent combo box references and/or in the "after update event procedure" but I just can't seem to figure out the exact changes to make to my database. Details:

Tables with data for combo boxes:LOOKUP TABLE - Veg Species - Species Type,
LOOKUP TABLE - Veg Species - Species Name.
Related together based on common field: SpeciesType

[code]...

When the form with the combo boxes is embedded as above, I can select the species type from the dropdown but when I try to select the species common name value I am asked to

"enter parameter value - Forms!SUBFORM2a - Enter Specific Veg Info!cmbSpecies_Type".

View 5 Replies View Related

Cascading Combo Boxes In Subform - Need Help

Nov 29, 2006

I have cascading combo boxes in a subform. When I click the second box, which is dependent on the first, I get the following error:

"Object does not support this property or method"

This is what I have for the On Enter Event:

Me!LeadIn.Updated Form!LeadIn.Requery

I originally had : Me.LeadIn.Requery for the On Enter, but it prompted a parameter box looking for the Phone_Card form.

I think I have to adjust the OnEnter even syntax, but I cannot figure it out.

Here are the names of the forms:
Main Form: Updated Form
SubForm: Phone_Card

Control Names:

Combo Box 1: Brand
Combo Box 2: LeadIn

In doing a net search, I believe it should look something like this:

Me!Leadin.Form!leadin.requery ??

I should also add that the subform is in a tab control: TabCtl197 if that matters. Also, when I use the combo boxes while having the Phone_Card form open, they work fine. It is only when using it as a subform that it no longer works.

Thanks for any advice or help!

View 2 Replies View Related

Modules & VBA :: Subquery Where Subform Is Shared Between 2 Forms

Mar 28, 2015

There are 2 mainforms and both of them share a subform. This subform is an add subform and I want the mainform to be refreshed after the data entry.Prior to the sharing, I had it coded it the way below and it works fine

Code:
Forms!frmMainformnoproc!frmActiveTasks.Requery

How would I recode this requery when it shared between 2 forms. frmMainformnoproc is the name of one of the main forms.The code above was present after an update was completed in the subform. Maybe I should be doing it after I close the subform and refresh the mainform. Based on that line of thinking I tried to add the code in the Activate event / Got Focus event of the mainform but the form did not get refreshed.

View 13 Replies View Related

Forms :: Cascading Comboboxes In A Subform

Mar 24, 2014

In my sub form I have two combo boxes named [wps] and [process ], I want to be able to filter process based on the value in wps.

View 3 Replies View Related

Forms :: Cascading Combo Box Setup

Jan 20, 2015

We've got an Access Database that I've edited in the past, I've got the cascading combo boxes set up so that, depending on which employee is selected, different "rate" options appear as work done. If I open the database afresh and select an employee (for example, employee 9 in Image 1 and employee 19 in image 3) the rates given to that employee are correct.

However, if the database remains open, I can't get the rates to update with the selected employee - even if the employee is clicked, rentered, etc.

Image 1: Freshly opened database, - Correct Rates
Image 2: Database remains open, - Incorrect Rates
Image 3: Freshly opened database, - Correct Rate
Image 4: Database remains open, - Incorrect Rates

I've tried to make it requery when clicked... or before the event... or on form click... or anything, but it doesn't want to know.

View 2 Replies View Related

Forms :: Cascading Combo Box SQL Backend

Jan 14, 2015

I have a cascading combo box that successuflyl returns data from sql server tables venue and date, when I save the record it saves the values but when I re open the record for a particular patient the combo box values are cleared and do not display patients appointment venue and date although it is saved in the database. How can I return the values in the combo boxes which were saved.

View 11 Replies View Related

Forms :: Cascading Combo Box - Loses Value

Mar 21, 2013

I have built several combo boxes in other DB's but haven't had this happen before. I am adapting a template DB to work for me. The form is continuous and I added a field [CategoryID], I want the [ProductID] to filter based on CategoryID choice. Pretty straight forward and it works, but the [ProductID] field will not hold the text value. It's a number field to hold the ID value, and bound column is 1(Select query is ID,ProductName,StandardCost) with ID and StandardCost column widths set to 0cm. I can choose CategoryID, the ProductID combo filters correctly, then when I proceed to the next record, the ProductID goes blank.

View 9 Replies View Related

Forms :: Triple Cascading Combo Boxes?

Jul 24, 2013

I have a form with various input boxes, three of which are combo boxes. These combo boxes need to affect one another. So let's call these cmb1, cmb2 & cmb3.

Hypothetically let's say:

Within cmb1 the list is A, B, C & D

If the user was to choose A, cmb2 would show the options 1, 2, 3, 4, 5 etc..
If the user was to choose B, cmb2 would show the options 2, 4, 6, 8, 10 etc..
if the user was to choose C, cmb2 would show the options 1, 3, 5, 7, 9 etc..

(So, it is possible that if the user chooses A from cmb1, cmb2 would show 1 and if the user chooses C from cmb1, cmb2 would also show 1)

Using the example in the brackets above:

If the user chose cmb1 - A then chose cmb2 - 1, cmb3 would then show the options Option1, Option2, Option3 etc..

BUT

If the user chose cmb1 - C then chose cmb2 - 1, cmb3 would then show the options Random1, Random2, Random3 etc..

At the moment I have a table with 3 columns. Within the table is every possible combination of the drop down, i.e:

-A l 1 l Option1 l
-A l 1 l Option2 l
-C l 1 l Random1 l
-C l 1 l Random2 l
Etc...

I have tried to use the example shown on this website but i've had no luck: fontstuff.com/access/acctut10 (If you look at "Example 2", thats what I tried to do)

View 7 Replies View Related

Forms :: Updating Table From Cascading Combo Box(s) Fox?

Mar 25, 2013

updating my table when I use cascading combo boxes in my form.What is happening is that my table is being populated by the xxxxID column vice from the xxxxName column that is being used from that specific table.

here is my visual basic code that I am using to determine what the subsequent combo box will display.

Option Compare Database
Option Explicit
Private Sub cboPlanktonID_AfterUpdate()
' Set the Family combo box to be limited by the selected Plankton Type
Me.cboFamilyID.RowSource = "SELECT tblFamily.FamilyID, tblFamily.FamilyName FROM tblFamily " & _
" WHERE OrderID = " & Nz(Me.cboPlanktonID) & _
" ORDER BY FamilyName"

[code]...

Example of the Combo box Row Source is: SELECT [tblWaterbody].[WaterbodyID], [tblWaterbody].[WaterbodyName] FROM tblWaterbody;

My Control Source is PlanktonAnalysis.WaterbodyName

When I fill in the form with the data, The Waterbody name is visable for selection (example: I see "Lake Lillinonah" in the cascading combo box, But when I save the record in the PlanktonAnalysis Table I get a number in the WaterbodyName column vice the name of the waterbody

PlanktonAnalysisIDWaterbodyName172
311411511677118397104113
tblWaterbodyWaterbodyIDWaterbodyName2Ashland Pond3Bantam Lake4Crystal Lake5Gardner Lake6Hungerford Park Pond7Lake Lillinonah8Lower Bolton Lake9Middle Bolton Lake10Pocotopaug Lake11West Thompson Reservoir

View 4 Replies View Related

Forms :: Cascading Combo Box Based On A Check Box Value

May 6, 2014

On a form I am making, I have two combo boxes. Box 1 has "Title" and Box 2 has "Full Name". In the table associated with FullName, there is a Check Box name "Still Attached".

What I am trying to do when choosing a "Title" in Combo Box 1, I would like only the people with that "Title" and a check in "Still Attached" to be available in the drop down list.

I have tried and I can get combo 2 to filter by title, but not by the "Still Attached" value.

View 11 Replies View Related

Forms :: Cascading Combo Boxes Setup

Jun 24, 2014

I am totally new to Visual Basic.I have dependent cascading combo boxes setup. The hierarchy goes:

Segment
Family
Class
Brick

Now, I need the value in the Brick field to create a varying number of other cascading combo boxes. They are the Brick Attributes. The brick attributes are the labels for the combo boxes and the brick attribute values would be the values you can chose from within the combo boxes. Depending on which Brick you chose, there are a varying number of Brick Attributes, and thus a varying number of needed combo boxes to pop up.

View 14 Replies View Related

Forms :: Stuck With Cascading Combo Boxes

Feb 6, 2015

OK, I so I am trying to filter one combbox tbltCatch from tblLocation (which is a sub filter from tblLocationCategory). Thing is, I am trying to select "Catches" filtered from the tblLocationCategory table. Reason being is because the "Catches" are the same the location types (example below). I know the code I am trying to utilize is incorrect and needs to be modified.

Code:
Dim sCatchLocation As String

sCatchLocation = "SELECT [tblCatches].[Catches_ID], [tblCatches].[LocationCategory_ID], [tblCatches].[Catches] " & _
"FROM tblCatches " & _
"WHERE [tblCatches].[LocationCategory_ID] = " & Me.cboLocal.Value
Me.cboCatches.RowSource = sCatchLocation
Me.cboCatches.Requery
Me.Refresh

View 14 Replies View Related

Forms :: How To Create Cascading Combo Boxes

Jun 10, 2015

how to create the cascading combo boxes that I need. For this, I have three tables:

Locations -- All store locations
Products -- Part Number and DESCRIPTION of any type of item that is available for rent
Serial Numbers -- (Unique) Serial number for each individual product, with its Product ID (foreign key) and Location ID (foreign key)

Each location has its own set of products available for rent, each with their own serial number. There may be more than one of the same TYPE of product at a location, but there will never be a repeated serial number.

I would like to have three (cascading) combo boxes. The first would allow the user to select a LOCATION. The second will have a list of all the types of products available at that location (DESCRIPTION). The third should have the list of SERIAL NUMBERS available at that LOCATION for that type of product (DESCRIPTION).

View 3 Replies View Related

Forms :: Cascading Combo Box Not Displaying Properly

Nov 18, 2013

I have a cascading combo box on a work order form that pulls the contacts from the customer selected in the main box.

It's working fine, values are printing fine on the reports, etc. however on the form itself - when you change from one record to another....the value is not displayed even though it's there if you click the report.

View 5 Replies View Related

Forms :: Cascading Combo Box - Cannot Choose Contact?

Jan 7, 2014

I have two combo boxes. One with the customer and one with the customer contact. These boxes seem to be working fine however, after you select the customer and then the customer contact box updates, it isn't allowing me to choose the contact. Nothing happens when you click.

View 7 Replies View Related

Bound Cascading Combo Boxes In Continous Forms

Jul 19, 2006

My goal is to have two combo boxes the first filters the second. it controls the semester that I am viewing. This works if i don't use continous forms but when i do it requeries every record in the form instead of the current record. I am not an access or vb guy but i have picked a lot up. please help!!!


I have attached a copy of my database.

View 4 Replies View Related

Forms :: Selecting A Table To Be Populated Using Cascading Combo Box

Aug 6, 2013

I am trying to use a combo box to control which table a data entry form will write data to. I want to create a form that has a combo box to select from a top level table that I will call "Stores". Once a "Store" is selected from the drop down, the next field on the form will be a data entry field. The data entered in that field will be written to the table selected by the preceding combo box.

So, basically I would have say Wal-Mart, Macy's, Sears, K-Mart and etc, listed in my "Stores" table. Once I select one of the stores from the drop down, I would then enter a "department" name in the data entry field and based on which store I selected from the previous combo box, the data would be written to that stores department table (which each store will have its own department table), e.g., WalMartDepts, MacyDepts, SearsDepts, etc...

View 1 Replies View Related

Forms :: Cascading Combo Boxes (multiple Filters)

Feb 23, 2015

I'm having some issues using the cascading combo box technique on my form.

I have a form, which contains a subform in continuous view, which contains a few combo boxes.

One of those combo boxes (available resources) should be filtered depending on the value of 3 other combo boxes (task types, source languages, target languages).

What I would like to be able to do is run the filtering routine on this resources cbo (currently VBA code that changes the row source value) when the user clicks on it.

It's kind of working right now: when I click on the arrow to open up the drop down list, the values are indeed filtered. The problem I'm having though is that, if I then click on that same cbo for another record (or any other cbo in another record for that matter), the resource cbo of the record I previously set gets deleted.

View 14 Replies View Related

Forms :: Cascading Combo Box To Select Record To Edit

Sep 19, 2013

I am attempting to create an attendance database that needs to be able to be updated if someone calls in sick.

I have created a cascading combo box where you can select a date up to 15 days into the past with the following code in the rowsource for cboDate

Code:
SELECT DISTINCT tblAttendance.dataDate FROM tblAttendance WHERE (((tblAttendance.dataDate)>Date()-15)) ORDER BY tblAttendance.dataDate DESC;

an after update event has been coded to show only employees who have been scheduled for the day

Code:
Private Sub cboDate_AfterUpdate()
On Error Resume Next
Me.cboAgentName.RowSource = "Select tblAttendance.agentName, tblAttendance.attendance,

[Code]....

So basically what i need to do is be able to use the cascading combo boxes to select the date and employee to go to that specific record so i can update the other fields. Currently when i attempt to do this with my current form, it automatically goes to a new record when i select a date and name and doesn't update the existing record.

View 1 Replies View Related

Forms :: Cascading Combo Boxes With Default Values

May 4, 2013

I've got a form (frmMain) with two combo boxes (cmbCategory and cmbProducts). I have set the combo boxes up to be cascading, so that when you select a value in the cmbCategory box, it influences what is visible and selectable in the cmbProducts box. What I wanted to happen is this:

1. User selects a category
2. cmbProducts defaults to the most recently entered Product within that category, and the form pulls up that product's details.

I have the cascading combo boxes set up so cmbCategory has an AfterUpdate event that runs a macro. In the macro is the command to refresh the cmbProducts box, and the cmbProducts box's RecordSource is set to a query that filters the Products based on the value of the cmbCategory box. I then set the cmbProducts Default Value to a DMax command that pulls the largest ID number from the query. Everything works great, except when I choose one category (the correct product comes up, the latest one entered for that product), then go back and choose a different category without reloading the form. The cmbProducts box stays showing the previous Product, and doesn't automatically update with the latest product for the new category. So it works the first time out of the gate, then just stops working, and won't work until I close and reopen the form again.

I've tried the refresh command, and I've tried adding an AfterChange event to the cmbCategories box. Nothing seems to work! I also tried running a close form/open form command in cmbProducts' After Update to enable the DMax command again, but this blanks out my Categories and Products boxes (which it's supposed to... I don't want anything to come up when you first open the form, both should be blank until you start selecting values).

View 2 Replies View Related

Forms :: Document Control - Cascading Combo Select

Jan 16, 2015

I am creating simple db for document control..

DB consist of 3 Tables:
tblCountry
tblState
tblCity

and a Form (frmCity) with cascading combo boxes that allows us to enter new City with existing data.

Combo's are displaying data fine but it don't allow selecting any item.

Shortly, this is what I have done so far:

1. Created cb's: cboContinet, cbo_State and cbo_City

2. Created query's:
a) qryState (added fileds are from tblState- State and Continent)
b) qryCity (fields are from tblCity- City and State)

3. Edit query's: qryState> added criteria for field Continent ([Forms]![FormName]![cboContinet])
I also added criteria in qryCity, field State ([Forms]![FormName]]![cboState])

4. Added VBA on After Update Event:

Private Sub cboDosje_AfterUpdate()
Me.cboGrupa.Requery
Me.cboPredmet.Requery
End Sub

[Code] .....

Macros are enabled in Trust Center and Combo boxes are refreshing fine, but somehow I can't select anything.

Also, I am working with Access 2007 if it matters, I've read something about allowing edits but didn't found how enable them.

View 4 Replies View Related

Forms :: Cascading Combo Boxes - Maintain Filter?

Jun 3, 2013

How to properly use 3 cascading combo boxes.

I have them set up and they work, to some degree.

I have three boxes Type/Sub-Type/Item. They all filter down to the next one, the problem is, when I get to the 3rd box, it filters ONLY from the 2nd box and loses the filter from the 1st. What do I need to do to get it to maintain the filter from the first box and then ADD the filter from the second box when populating the 3rd box?

View 2 Replies View Related

Forms :: Parameter Value Error When Doing Cascading Combo Boxes?

Jun 12, 2013

tried following Microsoft example and several others but my problem comes up when I click on Group in Ticket list, I get a parameter value popup. I know I'm getting it from my Where statement that is supposed to setup the row source for Category. I tried using numbers and text but I messed up somewhere when it comes to the vba.

Me.cboCategory.RowSource = "SELECT DISTINCT Category.Categories FROM" & _
" Category WHERE GroupName = " & Me.cboGroup & _
" ORDER BY Category.Categories"
Me.cboCategory = Me.cboCategory.ItemData(0)

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved