Filtering Combo Boxes Within A Form

Help Needed Filtering A Form Using Combo Boxes
Please help. My inability to achieve this is very frustrating.

I have a tabular form based on a query, which returns a large number of records. I need users to be able to filter the records to display data relating to what they have entered in a number of combo boxes.

For example I have fields showing Product ID, Manufacturer ID, Purchase Order number and due date. Each of these fields has a corresponding unbound combo box where users can select values that appear in the table. I need to be able to filter the form based on what is in these combo boxes. I.e. Filler for a product ID to show all purchase orders numbers and due dates relating to that product ID or filter for a manufacturer ID and due date to show all Product IDs and purchase orders relating to that a manufacturer and date.

Ideally this would be achieved by pressing a command button.

The query, table and combo boxes are all built and work fine but I am unable to get the filter to work, I am using Access 97 and am not very familiar with visual basic. Any help would be appreciated.

Thanks.

View Replies !

---

Filtering On Combo Boxes
I have a question about filtering on combo boxes. I was able to set up a form with 2 sub-forms, but it's more than what I need.

What I want it to do, is when the user makes the selection on the first combo box, I want it to filter on that selection and then drop that into the 2nd combo box. When the user makes the selection on teh 2nd combo box, then it should filter the results to a sub-form.

Any help? I have the relationships, and can get it to work when I have 1 form, and 2 sub-forms, but I really want just 1 form, with 1 subform.

View Replies !

---

Filtering Out Items In Combo Boxes
Need some help here....

I am designing a database to keep track of workers for a haunted house. I have a Roster table, a table of all the nights we are open, a table of Spots in the house, and a table to record who works what nights and what spot they are in. This table has a Room combo box and a Spot combo box. The Room combo has a Row Source of SELECT DISTINCT SpotsAll.Room FROM SpotsAll ORDER BY SpotsAll.Room; The Spot combo is then populated with VB code all the Spots that are in that room. That works fine. This is what I'm trying to accomplish: When a Spot is assigned to a Worker for that night, I want that spot to no longer be available in that list FOR THAT PARTICULAR NIGHT. So, lets say Joe Somebody works in Spot 1 (out of 4 lets say) of the Library Room, when we assign another person to the Library room, I don't want Spot 1 in the Spot list.

Can this be done with a query or VB code? If I'm not making sense, please let me know. I can also upload the Database I am creating so that you can play around with it and see what I mean.

(I have attached a word doc. that shows the table relationships.)


Thanks a lot ahead of time!!
ScrmingWhisprs

View Replies !

---

Combo Boxes Filtering Or Populting Same Records
Anyone help
I have 2 combo boxes cd group and cd name when I select CD group the records only associated yo that cd name display with that group.

Anyway, also the name of songs form works too,. So then now when I go from record to record the records display right with the songs and not with the cd group and name when I select Mormon Tabernacle Chior and name God Bless Ammerica it disaplys for all the records any help.

Why is it the relationships.

Thanks,

Nike Van der stad
mikevds@optonline.net

View Replies !

---

Filtering With 2 Combo Boxes And Then Populating Text/memo Fields
I have two questions.
I have a form with 2 combo boxes. The first pulls from a simple list. Once you make a choice, the second combo box is then filtered by the first. This works correct, except that once a choice is made in the first, the filter is locked. If you change the first combo box's value a second time it does not effect the second box. The query that I am using for the second combo box has two columns that pull the first 50 characters of a pair of memo fields. Quote: SELECT MSSS.SS_ID, Left([Application_Name],50) AS Expr1, Left([Description],50) AS Expr2, MSSS.Site_Code
FROM MSSS
WHERE (((MSSS.Site_Code)=[Forms]![Edit or Delete Requests]![Combo6])); These fields are then used to populate 2 text fields using an event procedure. Quote: Private Sub Combo10_AfterUpdate()
' Display Partial Application Name and Description based on choice
Me!txtApplication_Name = Me!Combo10.Column(1)
Me!txtDescription = Me!Combo10.Column(2)
End Sub This is working fine, but it starts the next problem.

I need to change the form to include the entire memo field into a text box. I was using the columns of the second combo box to fill them in. Since the combo box is limited to only 50 characters, i could only grab part of it. I am guessing there is a much better way to accomplish what I need, but I am too inexperienced with forms and vb to come up with it. Below are the fields I need from table MSSS
Business_Name
Application_Name
Description
Acronym
Level_1_Support
Level_2_Support
Escalation_process
Troubleshooting
Priority
Links
Modified
Disabled

Thanks in advance to any help!

View Replies !

---

Please Help. Question About Filtering On Reports With Combo Boxes, Many Linked Tables
Hello,

I hope someone can help me.

I am working on a Marketing Database to centralise information about our customers so that field sales can search customers that would fit a similar sales situation, by vertical market, by product sold, by competitive products etc.

I have created many tables and linked them together:
The main table is Customer Accounts (tblAccounts) and contains information such as:
AcntID (AutoNumber)
AcntName (text, Primary Key)
NAMID (number), relates to Account Manager table (tblNAMs)
SalesRegionID (number), relates to Sales region table (tblRegion)
PartnerID (number) relates to Partner table (tblPartners)
AcntCustomerSince (number)

tblNAMs contains:
NAMID (AutoNumber)
NAMName (Text, Primary Key)

tblPartners contains:
PartnerID (AutoNumber)
PartnerName (text, Primary Key)

tblRegion contains:
RegionID (AutoNumber)
RegionName (text, Primary Key)

Those last 3 table relate to the tblAcnt by intermediate relationships

I have also the following tables:

tblVendor contains:
VendorID (AutoNumber)
VendorName (Text)

tblProducts contains:
ProductID (autoNumber)
ProductName (text)
VendorID (Number)

tblToolsBfr contains:
ToolsBfrID (AutoNumber)
AcntID (Number, Primary Key)
VendorID (Number, Primary Key)
ProductID (Number, Primary Key)

tblToolsSold contains:
ToolsSoldID (AutoNumber)
AcntID (Number, Primary Key)
VendorID (Number, Primary Key)

tblToolsAftr contains:
ToolsAftrID (AutoNumber)
AcntID (Number, Primary Key)
VendorID (Number, Primary Key)

tblVendors and tblProducts are linked to tblToolsSold, tblToolsBfr, tblToolsAftr. Those last 3 tables are linked to the tblAcnt via the AcntID link

I have created a report that can show all this information on one page, per account.

I have also created a filter using combo boxes to allow me to drill down to Sales Region and/or Account Manager and/or Partner.

I am struggling with the rest of the filter as I would like to also filter what can be found in the tblToolsBfr, tblToolsSold and tblToolsAftr but because Vendors and Products are located in two different tables, I do not know what I should put in Row Source or as an event procedure or query.

Please can you help me, perhaps there is an example I could use?

I really hope someone can help as I am completely stuck on this for the past 3 days.

Valibal

View Replies !

---

More Than Two Combo Boxes In A Form
Hello to everyone!

I have a serious issue to solve and I would like to ask for your help, as I just don't seem to know how and where to start from.

I need to make a database that will have 2 tables, say tbl_item and tbl_offer. The items table will have different cardboard dimensions and other characteristics (width, height, color, photo, price etc) while the tbl_offer will have different combinations of clients' cardboard requests.

The workflow is:

A client comes and asks for:

- two pieces of cardboard of 120x100 cm
- five pieces of cardboard of 135x90 cm
- one piece of cardboard of 110x125 cm

I want to be able to enter the client's request in a form and the form will do 2 things:

1. Store the clients request as a record in the table tbl_offer (for current or future referrence)
2. Create a report (out of the above record) that will be printed out and given to the client (but I suppose that's easy...)

Now tbl_item has different types of cardboard (their code names) along with different dimensions and price for each, for example:

Type|Width|Height|Price
----------------------------
001 | 120 | 100 | 10
001 | 135 | 190 | 12
001 | 110 | 125 | 11
001 | 110 | 100 | 16
001 | 150 | 100 | 12
002 | 165 | 170 | 17
002 | 140 | 105 | 10
002 | 140 | 130 | 18
002 | 170 | 130 | 18


The problems are

1. I don't know exactly how I can create a form (say frm_offer) that will give me the possibility to add many different cardboard types and save them as one offer to the tbl_offer. What I would like is to choose from a combobox (or any other similar function) the type (say 002) and by this selection a second combobox would be filled only with the available Width dimensions for this type (165, 140, 170). By choosing what I want from the width combobox, a third combobox would be available that would give me the available height dimensions for this width (if for example I chose Type 002 and Width 140, the last combobox would give me two choices, 105 and 130). After choosing the Height I want, I would fill in a text box of how many pieces the client wants and the form would also fill automatically the cost of all the pieces for that dimension (by taking the price/item from the tbl_item perhaps?). If 1 piece then it should say i.e. 18 for the 140x130 piece, if 10 pieces it should say 180. Finally, I want to add the photo of the cardboard automatically (pls note that same type of cardboards share the same photo) not at the form but at the report to be printed.

I have already looked in the Access FAQs section of the forum for the combobox techniques but I can't understand how I can apply them to three (or more) comboboxes plus the photo.

I can use Access only when little/no programming is required, and I am very much afraid that all the above will require a great deal of it, so I apologise in advance for my non-knowledge of programming :(

2. How do you think would be suitable to split all this data to tables? Is my thinking correct (2 tables, tbl_item and tbl_offer) or would you suggest something better? Will the tbl_offer get a lot of data that way? Mind you also that every once a year there is the need of updating the cardboards' prices (all will rise/fall at the same percentage) and, furthermore, we are talking for about approx. 100 different types of cardboards, each with about 15 different dimension combinations.

I am not sure if I had to post this message to the Tables section of the forum or here but I think here is better as the main problem is the form part.


Thank you all in advance and my apologies once again for the low level of my programming skills :(


Alexander

View Replies !

---

Multiple Combo Boxes On Same Form
I need a form that has multiple categories, 7, listed one after another vertically. I also need the categories divided in to 2 columns.
I need to have 2 combo boxes, 1 each controlling the info for each column.
Can I do this on 1 form. Suggestions would be appreciated.

Freddie

View Replies !

---

Cont Form With Combo Boxes
I have a continous form that once the combo box filters are selected, shows the applicable records. Included in records, I've put a bound combo box that allows the user to fill in that particular field. This works with the first record but when you attempt to select the other records, all the combo boxes disappear. What am I doing wrong here??

View Replies !

---

Multiple Combo Boxes On The Form
Hi,

I need help in the following 2 problems:

I have two combo boxes on the form and print button.
In one combo box showing numbers 1,2,3,4 and 5.
Other combo box showing logical operator =,<,>
User is going to select from one combo box logical operator and from other number "means class field".
Print button prints the report. Report is based on the query.
In the query in criteria line I put the code
[FORMS]![MAINFORM]![CMB_CLASS]
It works for one combo box. Problem is to get criteria from second combo box or concatenate the both criteria’s. In query criteria line it should show like <2 or =3 or what ever user is selecting.

Second problem is in the same line. Three text boxes and 2 combo boxes showing "OR" and "AND" For example in one text box user enters last_name and then he select "OR", second text box enter city and then he select "AND" from second combo box and third text box enter department. After selection he is going to click the print button to print the report.

I really appreciate if anyone knows the solution or they used this type of thing in there application.

Thanks

View Replies !

---

Autofill From Many Combo Boxes In One Form
Hi all! :D
I'm trying to make a form to autofill with customer data (from a database), with 4 columns (= 4 customers). Each column contains on top a combo box and below 5 text boxes with address, phone etc.
So i created a form and placed a combo-box (from wizard) with the option "Find a record on my form based on the value i selected in my combo box".
The problem is that this one combo box controls all the text boxes. Even if i create an other one, it still controls all of them.

So i'd like to ask: How can i link a combo box, to autofill specific textboxes?:confused:

Thanks... :)

View Replies !

---

Combo Boxes And Queries Again - Two On A Form
I have re-written this question as I think I managed to cause confusion!

(I really do need help!) My problem involves three tables. The first table is NAMES with an auto-number key field called NamesID.

The second table is a list of Dance Classes, called CLASSES again with an auto-number key field called ClassesID.

The third table is a list of MEMBERS in each dance class.

Obviously, the MEMBERS can belong to many CLASSES, and each of the CLASSES can consist of many MEMBERS.



My aim is to add a new record in MEMBERS by using a ComboBox containing records from the NAMES table.

On the form, I have a combo-box which shows me the list of CLASSES

(ComboClasses). I click on the class.

I then click on the NAMES combo-box, click on a name and want it to appear in the table of MEMBERS for the class shown in the CLASSES combo-box.

The problem

I am selecting the name using “ Select * From NAMES where Names.NamesID=[Forms]![FormName]![ComboNames] (supplied by supersubra) but how do I get the ClassesID into MEMBERS record.

At the moment, if I add a name that member appears in every class, or I have to manually insert the ClassID.



Philip

View Replies !

---

Unbound Combo Boxes And A Form With Allow Edit Set To 'NO'
Hi folks,

I have a form with a record source property set to a query which pulls the data by joining two tables. The form also has four navigation buttons (first, previous, next, last) and a ADD record, SAVE record, EDIT record, DELETE record buttons.

I also have a unbound combo box (control source iset to 'empty') in the form's header section and its record source property set to an SQL (SELECT DISTINCTROW tblProjts1.chrProjectName, tblProjts1.intProjectID FROM tblProjts1 ORDER BY tblProjts1.chrProjectName;). It's columns count is 2, bound column is set to 2 and column width is set to 3.1146";0".

In the edit button, I have the code "Me.AllowEdits = True" so that the user can edit the data.

Also, I have the following code on form's "on current" and "after update" events so that it will flip back to allow edit to 'NO'
Me.AllowEdits = False

Also, I have the following code on the combo box's 'after update' event.
Dim strSearch As String

strSearch = "[intProjectID] = " & Me![cboProjectID]

'Find the record that matches the control
Me.Requery
Me.RecordsetClone.FindFirst strSearch
Me.Bookmark = Me.RecordsetClone.Bookmark.

My Problem:

When I run the form and select a record from a combo box it populates the fields (all memo data type) in the form with correct linked record, ONLY when my allow edit property is set to 'YES'.

With allow edit set to 'NO', then when a tried to make a selection from a combo box it doesn't allow me to select any record. The combo box seems to be locked up and I can't select any record.

Does anyone come across such a problem with cbo box and 'allow edits' property in the forms.

Your help is much appreciated.

ShanVel

View Replies !

---

VBA Code Problem With Combo Boxes On A Form
Im using the following vba Code to try and populate a text box with multiple line based on selections from a list box.

Private Sub Precautions_AfterUpdate()
Dim Criteria As String
Dim ctl As Control
Dim Itm As Variant

Set ctl = Me.Precautions

For Each Itm In ctl.ItemsSelected
If Len(Criteria) = 0 Then

Criteria = ctl.ItemData(Itm)
Else
Criteria = Criteria & "," & ctl.ItemData(Itm)
End If
Next Itm
Me.description = Criteria

End Sub

Its working to the extent that it adds the options that are selected from the list box but I actually want it to put the 2nd column of the list box which is hidden into the text box. How do i edit this code to add column 2 rather than column 1 when an option is clicked?

Any help would be appreciated

Ive attached the database (sorry its very simple) Open form tester to see what i mean.

View Replies !

---

Create A Form Using Selections From Combo Boxes
Hello

I need to create a form or a subform that brings up a list of records based on criteria that a user chooses in multiple list boxes. Is this possible? I am pretty new to Access.

Thanks,

albritm

View Replies !

---

Blank Combo Boxes Used For Form Selection
Hi All,

Am using a number of combo boxes as selection criteria for a report. The combo boxes are linked to a table, obviously there will be times when no criteria is required and will want to select "ALL" when left blank.

Is there a simple solution ?

Cheers

View Replies !

---

Ghost Values In Combo Boxes In Form!
I have set up a nice timesheet form now with lots of help on this forum.


I have a form with a subform(1) which has another subform(2). The form is NOT in Data Entry mode, so users can select their name from the main form, the period from subform(1), and then enter/edit timesheet records in subform(2). In subform(2), I have some combo and text boxes for each record. The first is cboProjectSelect. Column(2) of the selection made in cboProjectSelect is entered into tboProject. Additionally, the selection made in cboProjectSelect filters another combo, cboWorkstream. The records are displayed in datasheet view (I know I've been advised against this, but I've had to do this, because the users want to see all records as they enter their timesheets)

All this work beautifully....for the first record. For some reason, when you enter any subsequent records, it blanks out the values in the tboProject and cboWorkstream boxes for all records! If you click in any of them, the correct value appears, if you click away, it disappears.

The proper records are being entered in the relevant queries and tables, so everything is working fine. It's just annoying that the boxes go blank!

Any idea if there is a way to ensure the values don't disappear?

thanks in advance.

View Replies !

---

Open Relevant Form Based On 2 Combo Boxes?
Hey guys, I'm not sure if this is possible, and it is the most challenging thing that I have tried to implement into my database to date.

What I have is a booking form which allows you to Add Bookings for camera kits.

When a customer comes in and would like to book a kit, the form must be filled in with the relevant details, I have 2 combo boxes on this form.

The first is the Kit selection, there are 5 camera kits.
The second is an option to book the full kit out, or just components.

So here's the tricky part...

When the first combo box selection is made (eg. Kit 3) I need the Kit3 table to be active.

Then, when the user selects "Components" from the second combo box, I need a form to open up based on both of the above.

So a form based on tblKit3 would be opened and the user can manually select the components that they require to be booked out.

Any help at all would be appreciated.

View Replies !

---

1 Parameter Controlled By Multple Combo Boxes On A Form
Hi

I have been trying to set up this query via VBA code but, with no luck, have gone back to the query in design view. Basically the parameters of the query are determined by combo boxes in a form. This is fine if one combo box indicates one criteria but a problem arisis when multiple combo boxes are possible parameters for one field.

i.e. Field 1 = combo box one
field 2= combo box two
field three = combo box three, four or five.

i have found it difficult running this, especially in terms of a returning all if a combo is left blank. the problem with setting this up on field three would be that if i run combo box four and five to return all if left blank it overides the other command to set a specific parameter. Also, for some reason i can tdecide whether this is an AND or OR command, its actually both i.e. Field three parameter = combo box three and/or combo box4 etc...

please help this is driving me crazy.

Thanks

Shapman

View Replies !

---

Updating Relational Table From Form Using Combo-boxes
Hi,

I have two tables, tblCountry and tblLocation. With the following structure

tblCountry
ID
Name
Text

tblLocation
ID
Country_fk
Name
Text

As you can guess tblCountry lists all of the countries, tblLocation lists all of the locations in each country, the tblLocation.Country_fk field is linked to tblCountry.ID.

I want the user to be able to edit [tblLocation].[Text] using a form. They simply select the country and then the location using combo-boxes and then add or edit the content using a textbox.

In my form I have a combo-box that displays the country names, the RowSource is set to
SELECT [tblCountry].[ID], [tblCountry].[Name], FROM tblCountry ORDER BY [Name];

I then have a second combo-box that lists the locations for the selected country. This uses an AfterUpdate() procedure to select [tblLocation].[ID] using an SQL query based on the value of the country combo-box. I.e:

SELECT [tblLocation].[ID],[tblLocation].[Name],[tblLocation].[Text] FROM tblLocation WHERE [Country_fk] = " & Me.country_box.Value & " Order By [Name]"


I want to be able to have a textbox that then displays [tblLocation].[Text] for the selected location. Thats where the problem arises. I can't find a way that will let me display any content thats available for the selected location AND let me edit it. I've tried using UpdateAfter procedures, different bindings (tables, queries based on the value of location combo-box).

Can anyone suggest how I can display [tblLocation].[Text] based on the value of the selected country/location and be able to update the information via a textbox?

Any help would be appreciated!!!

Thanks

Jon

View Replies !

---

REFRESH Combo Boxes For Records On Continous Form
Background:
I have a continous form linked to a table and I have 3 combo boxes on the
form (linked to fields on the table). The combo boxes are called JOB TITLE,
SCHEDULE and SHIFT. The source for the combo boxes are queries named
respectively as LKUPJOB, LKUPSCHEDULE and LKUPSHIFT. For the three combo boxes listed abpve, the bound column is the first field of the underlying query and the column width of the first field is set to 0" (so that the second field of the query is displayed).

The way things should work is that for each record on the form, the
LKUPSCHEDULE and LKUPSHIFT queries (queries for the SCHEDULE and SHIFT combo boxes), the queries are filtered based on the bound field of the JOB TITLE combo box. The name of the bound field for the JOB TITLE combo is called Labor_Rate_ID.


Problem:
Unfortunately, It seems like the value of the labor-rate_ID in the first
record (i.e. first job title combo box) determines the query list used by the
SCHEDULE and SHIFT comboboxes for all the other records on the form. That is, even though the form has lots of records displayed, the combo boxes for each record don't have a complete list to work with.

Hence, the SCHEDULE and SHIFT combo boxes for some records are showing a blank (since available otions in the combo query list don't match the value
in the table for that record.

Can anybody tell me how to get a continous form to refress the list for each
record on the form.

I also don't know whether the Requery command for a macro could work and how to use it. I think though, that this problem can't be solved by a macro.

Basically, the question is around what kind of code will let you manipulate the properties of individual controls of a form at the Record level.

Pele

View Replies !

---

Combo Boxes Stop Working After Returning To Form
Hello all,

I have combo boxes populated with all values in a particular field, then shunt the form onto that record (standard combo box for selecting records from a list in other words).

Problem is, these boxes seem to stop working if I leave the form for another and then return to it.

Here's the code Access puts behind:

-----------
Set SerialRS = Me.Recordset.Clone
SerialRS.FindFirst "[Serial Number] = '" & Me![Combo60] & "'"
If Not SerialRS.EOF Then Me.Bookmark = SerialRS.Bookmark
-----------

The form may be opened and closed via other processes (although never unloaded), but when I come back to it these combo boxes always stop working! Why?

View Replies !

---

Text Boxes Showing Information From A Row In A Form Corresponding From A Combo Box
Hi,

I have a form that has several text boxes that correspond to a cell in a row. One of the columns contains just numbers 1-300. Now what I need is a combo box that contains the numbers 1-300 and when one of those numbers is selected I need it to import all the information from the same row into the correct text boxes.

For example when the number 3 is selected it will take the row with the number 3 in it, take all of the cells and import them into the right text box.

Thanks a bunch!

View Replies !

---

Multiple Combo Boxes In Form To Choose Groups Of Records
Hello,
I am wondering if it is possible to have several combo "boxes" in one form. The form is based on one table. In the table there are several fields which use a look-up (combo) drop down box to choose from: Type, Description, Manufacturer and Location.

In the form I want a combo box for Type, to bring up specific records in a subform, then I want a combo box for Description to bring up another set of records (within that Type of equipment) and a third combo box for Location to bring up all equipment within that location.

When I have tried to set this up - it changes some of the data in the in the subform - which changes it in the underlying table. If it set the form to open in New Record, then nothing shows up in the drop down box. Is there some If, THen code I could use to make it look first in the Type, then in the Description field, then close those out and look for the set of records that match in the location field?

Does that make sense?

I know how to manipulate in MSAccess templates, etc., but I don't know much about the underlying codes.

Thanks for any help!!!

View Replies !

---

Populating An Underlying Table When Using Cascading Combo Boxes In A Form
Hello everyone

I have read the FAQ on cascading combo boxes and have managed to apply the theory to my DB's data input form (frmDataEntry) which is very cool and prevents a lot of errors however in doing so it no longer populates the underlying table (tblProductionDetails).

I am at a loss as to how to correct this as you can see from the example I need the customer and description field to be populated with the correct data rather than the fields I am using to make the cascading combo boxes work.

Any help would be greatly appreciated

Regards

Adrian

View Replies !

---

***Multiple Combo Boxes On Form To Filter Subform Records!!!!
HI All,

This is been a trouble to me more than a week....already passed deadline.
Please help me.

I have 4 forms.

First form consists of Projects.
So if you choose any Project and click on command button for other forms then you can goto that form. This is ok with my work.

All forms(1,2,3)....are based on the qryProjects........and Each form has subform......and linked child field of subform with master field of master form.......so I can see all the records containing the particular selected project from the projects form......................

NOW my problem???????? is I have 3 cascading combo boxes to filter the records in subforms.....and printing the results of filtered records...................This one i tried to check many posts...but i got bad luck with all the sources..........PLEASE HELP ME....HERE I AM attaching my FIle....

View Replies !

---

Filtering - By Option Boxes Multiple
I am trying to design a form which will provide my users multiple reporting options using the same query.

my query contains the following fields:

Daycode
WeekNumber
PeriodNumber
Line
Machine
Eventcode
TotalTime
Occur
Avg

i want the user to choose in this order :

a time period to run the report.....either Daycode, WeekNumber,PeriodNumber

then select:

a Line,

then select either Totaltime, Occur or Avg (this will require to be sorted Desecnding..

then finally to decide wheter to have all the data remaining, or sorted by machine.

DB is here--------> Click here

View Replies !

---

Clearing Text Boxes/combo Boxes?
Another quick request:

What would the code be for a button which clears the contents of a text box or a combo box on a form?

Many thanks,

Paul.

View Replies !

---