Cascading Combos: Changing Which Field Is Displayed Once Selected

Oct 6, 2005

I have set up a form which has 2 combos.

Combo A pulls from a query which gets surgery address1, address2, and surgeryID. It displays only the first 2 fields.

Combo B gets info from a query getting staff firstname, surname, title, staffID and surgeryID, and shows the first 3 fields.

I have the following code in the afterupdate of box A (surgery_combo)

Private Sub surgery_combo_AfterUpdate()
staff_combo = 0
staff_combo.Requery
End Sub



HERE IS THE PROBLEM:

The queries seem to work fine, as box B displays the staff that work at each surgery. However on selecting a staff member, you can only SELECT the ones who have a salutation (mr/mrs etc) in the first column. And when you DO select this - the combo shows a most unhelpful "Mr" whereas I want the name there.

How do I change the column that the combo displays once selected?

View Replies


ADVERTISEMENT

Cascading Combos On Many-to-many

Mar 11, 2005

Hi!

I am trying to find a solution for this many to many relation and combos! I ve managed to do the one-to-many as the Mile-o example but i have trouble getting the same result right on many-to-many relations

as you know access needs us to create an extra table for many-to-many relations! but the example talks about the current an the previous table! how can i have 3 cascading combos with many to many relations to each other???

i also have a fourth but this one is related as one to many with the 3rd!

for more information i have:

Many Cars-to-many Categories of brands of parts
Many Categories-to-Many Brands of parts
One Brand-to-Many parts

the many parts combo is also a record selector!

In the beginning I had one table of parts with 4 foreign keys then i changed it to the current one with the previous chain of relation ending to parts with one foreign key! is this better???

Thanx! I hope I made my proble as clear as i could :)

Please Heeeeeeeeeeeeeeeeelp :) :)

View 3 Replies View Related

3 Cascading Combos

Sep 28, 2005

Can anyone kindly help me with the attached
database. I need to synchronize 3 combo boxes.
based on the choice made in the previous box.
I have seen it done before using text fields but
not using numeric fields as in my case here and
without using queries.

I have set the RowSource for the 3 boxes on the
OpenForm event and have removed all my code
attempts.

Thanks for your help

View 3 Replies View Related

Cascading Combos

Apr 2, 2006

I am new at programming in Access and I am writing a database for our church. I have 2 tables, one called “Donators” and the other “Donations”. In the Donators table I have their Last Name and First Name along with their address etc. In the Donations form I use a combo for the Last Name and a separate combo for the First Name. I did this so the person entering data doesn’t have to use a mouse but simply tab and type. Both combos are bound to the ID number. Without using a cascading combo, all First Names appear not just the ones relating to the Last Name. I checked the examples on cascading combos and tried them but without success. I could really use someone’s help. Thanks.

View 3 Replies View Related

Cascading Combos With Many Entries

Feb 25, 2005

Right i have a project form which has a sub form of location

One project can have many locations

therefore it is nescarry to enter more than one location

Problem is with the cascading combo boxes i have for country to region to sub region, is that you can enter one fine, but if you enter another is deletes the information from the first entry

can anyone fix this please

i have uploaded a sample

View 4 Replies View Related

Multiple Cascading Combos

Mar 3, 2006

Hi All,

I have a query about cascading and combo boxes, which I was kindly, advised about previously. However, I’m stuck as to how to cascade using the selections from more than one combo box. Here are the tables involved

tblLine
fld LineID (PK)
LineDesc

tblMachine
MachineID
MachineDesc

tblLine_Machine
LineMachineID (PK)
LineMachineDesc
LineID (FK)
MachineID (FK)

tblCategory
DTCategoryID (PK)
DTCategoryDesc

tblDTReason
DTReasonID (PK)
DTReasonDesc
tblCat_Mach_Reason
CatReasonID (PK)
DTCategoryID (FK)
MachineID (FK)
DTReasonID (FK)


What I’m trying to do is create a form to enter downtime incidences and would like the downtime reason to be selected following a series of combo boxes. The first combo box selects the Line on which the downtime has occurred, using this, the next combo box selects the machine. I would like the category selected independently but then need the Downtime Reason selected based on the selections in the machine combo box and the category combo box. This is where I am having the problem.

I can get the machine combo box to display machines dependent on the Line selected and I can get the downtime reasons combo box to display machines dependent on either the machine selected or the category selected, but I don’t know how to get it to do it based on both.

e.g. the category may be mechanical, but there are reasons that are mechanical and specific to each machine.

Any help with this would be most appreciated.

Regards

Keji

View 2 Replies View Related

Cascading Combos Issue

Feb 9, 2005

Hi,I shall be grateful for any help.

My problem

Tables:
Cars
Customer
Invoice
TblMake
Tbl Model

I have used cascading combos for Make and Model. They work fine. I have set up tblMake as follows:
ID
Make
I have make tblModel as follows:
ID
Make
Model
I use these cascading combos on a form. The data from this form goes into the "Cars" table. I have set the "Column Bound", "Width" etc. to show the name of the car, not the number.
However, I have created a search form. This uses a SELECT...... case in the Row Source. The details of each car are shown in a unbound listbox. This select case is supposed to show "Make" and "Model", which it does, however - they are numbers!!!
Please can anyone let me know how to change it so it shows the actual names of the car.
Thank you

View 3 Replies View Related

Cascading Combos In Datasheet View

May 5, 2005

OK, here is the problem. I have the following tables:

Customers
Consignment
ConsignDetails
Employees
Products
Suppliers
CompanyColors
CompanySizes

and I am creating a form to view the items currently on consignment with the customer. I have the main form 'Consignment' that holds the CustomerID, ConsignID, DateStarted, Employee (SalesPerson), Inventory Interval, and Closed (Y/N)... The subform lists in datasheet view the records in form 'ConsignDetails' that have the same ConsignID. The controls on the subform are :

ProductID
UnitPrice
Quantity
Color
Size

The ProductID is selected in a combobox from all products. The UnitPrice defaults to a DLookup() from the products table based on the ProductID, but can be changed and stored. The Quantity is a manual entry field. Color and Size are both supplier-dependent fields, in other words, the supplier of the product has unique Size and/or color codes or descriptions. I have no problem creating a combobox either in the AfterUpdate event of the ProductID or in the MouseDown event of the Color or Size field to limit the drop-down list to only those Colors/Sizes from the CompanyColors / CompanySizes tables with the same SupplierID as the Product in the first control.

So far so good, but here is where I am beating my head against the wall. Every time I choose a product from a different supplier, the Color and Size controls display ONLY the items from the current Supplier, not the items from the Supplier of the Product on their individual records. I have seen ways to make the combo popluate a locked textbox, hide the combo, and display only the text, but in a data entry application the user will be primarily on the keyboard, and the solutions seem to make it almost impossible to do without using the mouse over a continuous form.

I am using Access 2002 (ver 10.6501.6735) SP3 to create an ADP using MSDE to link to SQL7 tables....

Any help will be appreciated, I have spent almost two weeks trying different approaches and may be too close to the forest to see the trees.

Thanks,

Bruce Davis

View 14 Replies View Related

When Using Cascading Combos - Requerying Other Fields

Oct 6, 2005

OK ive got my 2 vaguely working combos which select the surgery, and the staff.

On the same form I want a couple of tickboxes which show for example, whether a person attended the course, if they had to pay etc (all yes/no answers).

How do I get the tickbox to update? i have tried to requery it but nothing happens, it just stays as what the last thing done to it was.

SHould i be using a subform here do you think?

View 1 Replies View Related

Cascading Combos Not Working When In A Subform

Oct 7, 2005

Heya

Ive got my combos working fine now (thanks to all you kind folk on this forum!) but now that I have opened the main form (in which the combo box form is nested), once I have selected an item in the first one, and then click on the 2nd combo, a parameter box comes up saying "Forms!Training Record!Course_title_combo" and wants a value.

I cant see why this doesnt work when the form is nested, any ideas?

Gazz

View 11 Replies View Related

Cascading Combos With Subform Problem

Oct 22, 2005

Hello to all !
I have this db where i wantto include 4 and if possible 5 cascading combos where the user can select records from a table and view them in a subform which is in datasheet view.
All is going well until i try to add the 4th combo.Then when i select the 4th combos selection the subform displays nothing.
If someone could point me to the right direction i would be most thankful.
I have attached the db.
Thx for all replies :)

View 7 Replies View Related

Cascading Combos On Continous Forms

May 12, 2006

Hi Guys,

I have two unbound cascading combo boxes on a form that limit the data for a stored field.

I am designing this as a subform to show software installed on a PC (hence the need to have a continuous form). As the manufacturer, software package and edition are already stored in my database, I am storing only the ID of the edition to limit duplicating data.

I would like to show the values in the cascading combos that relate to the edition ID stored as well as filtering the edition ID using the combo boxes (i guess a filter and a reverse lookup)

Please see attached pic. First record was entered as Microsoft Autoroute. New record for Manufacturer Frontier, change the previous records combos.

Thanks for you help

Ben

View 4 Replies View Related

The Selected Value Displayed In A Combobox

Apr 29, 2005

I'm sure this is simple and I'm just missing something...

I have a combo with two columns and the row source set up as a query which returns two columns.

When I click the drop-down arrow for the combo box, I get exactly what I expect.

What I want to do is initialize the combo box so that the "default" selection is displayed in the "text" or "value" section of the box. I also want to be able to update this when the user makes a selection.

I have no problems when using a list box with something like:
listbox.value = <Some Index in the listbox>

With the combo box, I've tried:
combobox.text = xxx
combobox.value = xxx
combobox.column = xxx
combobox.itemdata = xxx
combobox.listindex = xxx

The value property sort of works -- It displays the data from the first column right justified in the "text" section of the combo box. I need to have both columns displayed the way they are when the combobox is dropped down.

Any thoughts?

Thanks in advance...

View 3 Replies View Related

Changing The Order Records Are Displayed In A Subform

Feb 27, 2006

Hi everyone. I need help on this one

I have a form with a subform. The subform is basically the sale history of the item on the main form (The main form shows a record and then the subform reports its history). This all works fantastic, except that on the subform, every time a new record is entered, it goes to the bottom of the previous one, so after a while, if I want to enter more history into the subform, I have to scroll down through all the older ones to get to the more recent ones.

How can I do it so that in the subform the most recent entry is always at the top and each time a new record is entered, the older ones move down one. This way the most recent records are always on display and older ones move down as they become less important. Likewise, the empty record used to enter data is also at the top!

Thanks!!

View 14 Replies View Related

Changing The Way Data Is Displayed (for A Merge To MS Word)

Sep 23, 2004

Hi,

I am new to Access. I am a speech therapist and am building a database to keep up with my student's progress. I have set up the database satisfactorily (if rudimentarily, at this point), but am now trying to merge the data to a form on a MS word document that we use to file medicaid. Most of my tables and queries have one to many relationships because each student has several goals and in each therapy session we usually work on more than goal. On the medicaid form the information is organized by date. The only way I can envision to get the data to merge to the medicaid form is to use as the source a table or query where there is a single record for each date. But all the tables and queries I have figured out to build so far have multiple records with the same date, if we worked on more than goal in that session. (i.e. there is one record per each separate goal). For example, if you are visual like me.......

This is what I've got:

[date 1] [goal 1] [percentage for goal 1]
[date 1] [goal 2] [percentage for goal 2]
[date 1] [goal 3] [percentage for goal 3]

but this is what I need:

[date 1] [goal 1] [percentage for goal 1] [goal 2] [percentage for goal 2] [goal 3] [percentage for goal 3]

Is there any way to run a query that will reorganize the data in this way? I thought for a minute that a crosstab query would do it, but I don't need to perform a calculation, I just need to reorganize the way the data is displayed. .....perhaps something with a pivotform??? I haven't figured those out yet.

Thanks for any help.

Shan

View 2 Replies View Related

Manually Changing Displayed Record On A Form

Mar 7, 2006

I have a form that is linked to a table. tblContacts

On the form I have added a listbox which has every possible Contact (Name) listed. I wanted to be able to click on a contact name and then have the form bring up all the information related to the contact.

right now i have on the click of the listbox a msgbox that gives me the contact id associated with the contact name.

BTW, this is a project i am taking over from someone. If it was my choice I would be creating a web app.

View 2 Replies View Related

Cascading Combo Box Changing Records

Jul 13, 2006

I have attached a Microsoft inventory db that I have attempted to alter and apply to my needs.

I added cascading combo boxes to allow the users to make selections of products specific to categories. Once the category is selected in the CategoryID combobox the cascaded combo boxes ProductName & SerialNumber become populated with the products that belong to the category selected in CategoryID. This works as it should.

The problem comes after a record is selected and an attempt to switch categories is made. For example, say an inventory transaction for the product named "V1" which belongs to the "Special" category is entered. As soon as I switch back to the "Routine" category with the combobox, the product "V1" is now associated with the "Routine" category.

I know Access is just doing what it's supposed to but I need to find out how to prevent the category information for products from changing when a new category is selected in the first combobox. I've tried requeries, gotoRecords and various other commands without luck.

I have attached my db in hopes that a solution can be reached more efficiently.

Thanks in advance.

Shane

View 6 Replies View Related

Changing Display Based On Record Selected

Jan 26, 2006

I'm this is a simple issue. I have a combo box which can have the following status's: Not Started, In Progress, Complete. Depending on the value of the combo box i want a different image to show. So if not started is selected i want the user to see a red box. If Complete is chosen, a green box will show. i can do this easily enough but my problem comes in when i go to the next record. The boxes just stay visible regardless of what option is displayed. What event is triggered when you go to the next form?? Form Open / Load doesnt seem to work.
:mad:
:confused:

View 2 Replies View Related

Blank Field No Information Is Displayed

Sep 11, 2006

I know this is a simple question. I searched but could not find what I was looking for. Or it is handled in differently than what I am thinking.
I have a field where I enter a dollar amount. But if I do not enter a dollar amount the field displays $0.00. How can I make this field blank if no dollar amount is entered.

Thanks
For any help I can get

View 2 Replies View Related

Forms :: Label And Field Being Displayed On Another Form

Jun 6, 2013

I've added a label and field to a page on an existing form. However these are now also displayed on other pages on the same form.

View 1 Replies View Related

Total Of A Field In A Subform Displayed In Actual Form.

Jun 10, 2006

Hi.

I am setting up a database to run a shop. In my 'Orders' form, i have a subform of the order details (The item (combo box), price, quantity and subtotal (price*quantity).

In the form in which the subform is displayed, how can I display the total of the subtotals? Is it easy, could anyone show me roughly what i need to write?

Many, many thanks,

- Smiffezo.

View 2 Replies View Related

Field List Window Displayed In Form View

Jul 8, 2014

I have a form with a subform that has started a strange behavior... Periodically (no apparent pattern) whenever I leave the form (go to next record, print report, send an email...) the field list (Add Existing Field) box pops up. I always thought that those boxes (property sheet included) displayed or were hidden based on the state the last time it was used in Design View. I have confirmed that all forms and subforms do not have the boxes in display state in Design View.

I can go into Design View, close the box and all is well for awhile. It seems to happen more frequently when I go to print a report based on the data on the current form. My question is - what causes the Field List or Property Sheet to toggle on/off and can I suppress it either on a form or in the VBA code?

View 3 Replies View Related

General :: Scientific Notation Displayed When Entering Data In Number Field

Mar 4, 2013

I have a "Currency" field in a table and it holds large numbers (on which I will need to do basic arithmetic operations at some point, so I must store them as a numbers). I have set the "Standard" format on the TextBox used to display it on a form because I want to have thousand separators; I've also set "0" for decimals as I don't need to display them.

So everything displays as I want it even with the largest number that can be stored all the decimals are showing in the text field, but when I click on the field to edit the value instead of having the complete value it is displayed as scientific notation. I would like to display the complete value when editing it instead of the scientific notation, how can I achieve this, if it is possible?

A numeric example: If a user enters 1234567891012, the value displayed is indeed 1234567891012 but if they click on the field again the displayed value while editing is 1.23456789012E+11 (and it switches back to normal notation when the focus changes to another field). I would like to show 123456789012 all the time. I know that Access is capable of it most likely because if I set the Format to "Fixed" the values are always displayed completely (no scientific notation), but unfortunately I would like the thousands separators to show and it is not possible with the "Fixed" format.

Two last details, the scientific notation while editing does not kick in unless there is more than 11 digits in the number and the field width (and/or TextBox width) are sufficient to display up to 20 digits.

View 14 Replies View Related

Forms :: Using OnClick Event To Open Query Text Displayed In Form Field?

Oct 10, 2013

I have a table that holds the SQL texts for ca. 1000 Select queries (mostly minor variants that are used to programmatically swap out RowSource strings for combo boxes). I'd like to have a quick and easy way to open/review/modify these queries.

One strategy would be to display the SQL strings in a field on a Datasheet form, then use an onClick event on a text box linked to the SQL-holding field (or perhaps an onClick event tied to an unbound text box on the form) to open the associated query. That would allow me to view the SQL of the query that I want to open, allow me to quickly scroll through the list of stored SQL texts, and give me options for sorting or limiting the SQL-texts displayed in the datasheet form.

But, I can't seem to get the onClick event to work. The problem seems to be that I can't figure out how to pass the SQL string contained in the field to a function that will use that string to open the query .

View 10 Replies View Related

Forms :: Change Backcolor Of A Field On Current Record Displayed In Multiple Items Form

Apr 8, 2013

I wish to change the backcolor of a field on a current record being dispalyed in a 'multiple items' form. However when using me.A.backcolor = makes refrence to all fields called A on the 'multiple items' form and therefore all fields change colour not just the current record.

View 2 Replies View Related

Queries :: Cascading Combo Box - Filter By Field?

Mar 16, 2013

I want to create a cascading combo box - so far so simple, but in all the tutorials I can find the options in the second combo box are exclusive to the first e.g. combo box 1 selects "state", combo box 2 then displays "city". Each city can only be in one state.

In my scenario each city is in several different states - and so far I'm failing to come up with any sort of strategy as to how to deal with this. I tried giving each state a "yes/no" formatted field in the "city" table, figuring if I could use the first combo box to point access to the right field in the "city" table I could filter those records by "WHERE [fieldnominatedbycombobox1] =True" - but I don't know how to make a one combo box determine which field a subsequent combo box filters by.

View 13 Replies View Related







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