Limiting A Dropdown List In A Subform From Within The Subform

Jun 25, 2007

I have a subform within a main from which switches by entry. The subform is a datasheet. I have two dropdowns in the datasheet and I want to limit one off of the other. I keep getting a prompt. The prompt is Forms!CLTS Subform!Environment. To my understanding it looks like it can't find Environment. Does anyone know the proper format.

This is my code for the second drop down in the subform.
Also special note Environment is what I am referencing to and it also is in the subform.

SELECT PackageName.PackageNameID, PackageName.PackageName, PackageName.EnvironmentID
FROM PackageName
WHERE (((PackageName.EnvironmentID)=[Forms]![CLTS Subform]![Environment]))
ORDER BY PackageName.PackageName;

View Replies


ADVERTISEMENT

Display Specific Records In A Subform Using A Dropdown List

Apr 12, 2005

Hi to all,
I developed a database where I keep all the problems that I face and their solutions along with its category.

Now I want to have a form that when I choose each category, I should have all its records.

I heard that I should implement this by using a subform but I couldn't manage. With a search at the topics I've seen that I should use a macro but I don't know how to implement it.

Possibly after the lookup field I should have an After Update function but how can I connect it with the subform?

ex. at category "hardware: floppy" i have 2 records and i want to see only these, and when i choose category "hardware: hard disk" to have other 5 records of that category

Help plz?

View 9 Replies View Related

Limiting Records In A Subform To 24 - How To

Nov 17, 2005

Ladies / Gents !

I am writing a database for my work environment to enter sample numbers in a predefine batch. My Form contains information to identify batch ID. Attach to this form is a subform which I would like to limit the number of records to 24.

exsample: form : as unlimited records
subform: only limited to 24 records within the master form.

Now, everytime i create a new record in the master form , I should be allowed to enter only 24 records in the associated subform.

Does anyone have an idea on how to accomplish this !! Your help would be greatly appreciated.

Thank You

View 1 Replies View Related

Limiting Subform Data

Jul 8, 2005

Hi,

I'm baffled by this ...

One of the forms in my database has a subform. The subform displays data from a table which is related to the data in the main form (also powered by a table) through a key relationship. So long as the relationships are set up correctly, the correct data magically appears in the subform as you scroll through the records in the main form.

I've tried to do this a second time, except in this instance the subform is displaying data from a query, and the data is related to the data in the main form not through a direct key, but through a link table. I've set up the relationships properly as before, but this time the subform stubbornly displays all the data from the query, not just that which is related to the record in the main form.

What am I doing wrong?

View 2 Replies View Related

Forms :: Using One Dropdown List Box To Display A Selecting In Another Dropdown List Box?

Aug 4, 2014

I have a form where I have two drop down list box.The first list box is called Transaction_Type. It contains three values: Created, Allocated and Sold

The second list box is called Product_Status. It contains 6 items: Allocated, Produced, Reworked, Shipped, To Be Produced, Unallocated.

I have a products form. When a user created more inventory they will selected in the drop down list create, then a quantity. Then I would like the status of the product to update to "Unallocated".

When the user placed an order but doesn't finish it they will choose the status of the inventory to be allocated so I would like the product status to be updated to allocated automatically.

They other status the user will choose them self and do not need to be linked to each other.

In my vba code I have tried with the OnClick and AfterUpdate sub procedures with the following code.

If Me.Transaction_Type.Value = "Created" Then
Me.Product_Status.Value = "Unallocated"
End If
If Me.Transaction_Type.Value = "Allocated" Then
Me.Product_Status.Value = "Allocated"
End If

Yes when i select "created" from the drop down list it does not change product_status to say "unallocated"

(in using access 2007)

View 14 Replies View Related

Modules & VBA :: Limiting Dates Entered In Subform

Jan 20, 2014

I have a subform which users log their daily working hours (Mon - Fri) for 2 weeks. The subform is limiting the number of records to 10 or less. I would like to begin including the weekend in the form but don't want to include them as part of the 10.

Here is my code which works fine if I am only looking at the recordcount values.

The date field is [Reporting Date]

Private Sub Form_Current()
If RecordsetClone.RecordCount >= 10 Then
Me.AllowAdditions = False
Else
If RecordsetClone.RecordCount <= 10 Then
Me.AllowAdditions = True
End If
End If
End Sub

View 2 Replies View Related

SUBFORM - Dropdown Issues

Mar 8, 2005

Little help please… I have done this before but must be missing something small… you will need to download the db attached…too much to describe.

Please open the db. There will be a start form. Click on the first button tittled:

‘Client Form’

This will launch a main form with two subforms. All coming from the same query. I want one main drop-down with the ‘client name’ and when that name is selected then the fields within the subform to be populated with the corresponding information.

Right now if you open the form there is already information & when you select a clie t name from the drop-down the subfield does not even change.

What am I missing all???

Thanks

View 2 Replies View Related

General :: Dropdown List Dependent On Another Dropdown List

Jun 11, 2012

I must create a database for the company that I work for that covers the maintenance history of our stone crusher plant. In this database I have two dropdown lists. The first one is for the equipment and the second one is for the different types of parts that has to be replaced or fixed.

Not all of the equipment uses all of the listed parts, but some parts are used on more than one type of equipment.

I have already created a database that lists all the equipment and another one that lists all the parts.

What I want to do now is create a Yes/No box for each type of equipment so I can mark which parts is used by which equipment.

Then you must be able to select the type of equipment from a dropdown list and then select from a dropdown list that only has the parts that is used by the piece of equipment.

I am using Access 2007

View 4 Replies View Related

List Table, Limiting Field List..

Oct 14, 2006

Okay,

The subject is probably confusing but I'll try to explain.
Setup:

Table1
FieldID = Number
FieldName = Text

Table2
FieldID = Number
FieldName = Text
T1_ID = Number

Relationship
Table1.FieldID 1-> * Table2.T1_ID (one to many)

Now, I'm trying to create a 3rd table that has field populated by Table1 and a field populated by Table2 but I want to limit the field populated by table2 by what is selected in the field populated by table1.
Table1:

1st
2nd
3rd
4th

Table2:

1st,January
1st,February
1st,March
2nd,April
2nd,May
2nd,June
3rd,July
3rd,August
3rd,September
4th,October
4th,November
4th,December


Table3:
Table1Field = Number, ComboBox-Source: Table1, BoundColumn=1
Table2Field = Number, ComboBox-Source: Table2, BoundColumn=1

If Table1Field = 1st then
Table2Field Will only allow January, February, or March as selections, since ONLY they are a member of the "1sr" group via the table1 list.

Is this possible, or do i have to do some run-time checking or something?
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner

View 1 Replies View Related

Limiting List Box By Another Field

Apr 25, 2012

I'm trying to limit the funders under previous applications to ones with the same name so then when you click on one it loads that other funding application details...

Code:
SELECT [Sheet1].[ID], [Sheet1].[Funder] FROM Sheet1 WHERE [Sheet1.Funder] Like [Sheet1].[Funder] ORDER BY funder;

Code:
[Sheet1.Funder] Like '" & [Sheet1].[Funder] & "*' ORDER BY funder;

[code]...

View 14 Replies View Related

Limiting A List In Combo Box

Aug 20, 2013

I am very new to database design and application building. I work as general office support for a very small non profit. I have been tasked with developing a database to track HR and timesheet data and turning that into benefit reports. Actually, I was asked to create some spreadsheets to do this - but I strongly feel that access is a better solution than excel for this as we have around 150 individuals to track between all staff (part time, temporary, fulltime etc + regular volunteers).

So, the wall that I've hit that brings me to actually post instead of just search....

Some of our employees have more than one position, and in turn more than one rate of pay per month.

I created a compensation table that has the employee ID (from the employee table) and fields for position title, rate of pay and if that is per month or hour

I have a main timesheet table that assigns employee and month; and a details table that takes the timesheet ID and compensation ID with fund codes and hours worked.

My problem is that I don't know how to limit the combo box on the details sheet to just the positions assigned to the employee ID that matches the timesheet being worked with.

I tried all the design view access query options I could think of to limit the records in the combo and I always end up with all positions/rates of pay listed with no regard to employee ID....

View 1 Replies View Related

List Box Wiht Subform

Jun 16, 2005

I have the folloowing tables in the database

tblCD/Main: CdID - autonumber, CDName - text ...anything else will be a lookup field that we will get from another table, so we will come back to this table

tblAuthorType - AuthorTypeID - autonumber, AuthorTypeName - text. author type name will have, as I see it, 3 types : Composer, Group, Artist.

tblAuthorName - AuthorNameID - autonumber, AuthorName - text, - the name of all authors, composers and artists that u will pick from later

When I select Author which can be a cdgroup which is fine it will display those cd's related to the cdname. Such as Author TypeName Composer, Group. Artist.
tblTrackNumber - -Name of Song TrackNumID - autonumber, TrackNum
I have a subform and I want it to go to the tbktrack number with Name of Song related to that CD after I select an Author from the list box.

I am fairly new to this I need the vb codes for modification
mikevds@optonline.net

I set up these tables so then the relationships will refer back to them.

View 1 Replies View Related

Filtering A Subform Using A List Box

Jan 8, 2006

I've finally figured out how to populate my list box with radio buttons (3 companys listed on the radio buttons, you click one and employees for that particular company populates the list box). Now I'm trying to figure out how to click on an employee in that box and have their contact information populate the subform that holds that info.

After trying unsuccesfully with VB, I considered using a macro that would open the subform where the Last Name = the Last Name clicked in the list box, but I couldn't figure that out (couldn't figure out what the name would be for the selection in the list box) but I would prefer the subform be there permanantly in "add" mode untill a selection is made in the list box.

I'm code ignorant and rely on google and what books I have for reference / copy-past.....any ideas?

View 3 Replies View Related

Filtering A Subform Using A List Box

Jan 8, 2006

I've finally figured out how to populate my list box with radio buttons (3 companys listed on the radio buttons, you click one and employees for that particular company populates the list box). Now I'm trying to figure out how to click on an employee in that box and have their contact information populate the subform that holds that info.

After trying unsuccesfully with VB, I considered using a macro that would open the subform where the Last Name = the Last Name clicked in the list box, but I couldn't figure that out (couldn't figure out what the name would be for the selection in the list box) but I would prefer the subform be there permanantly in "add" mode untill a selection is made in the list box.

I'm code ignorant and rely on google and what books I have for reference / copy-past.....any ideas?

View 1 Replies View Related

List/Subform Update

Mar 28, 2006

I have a private sub on a subform called txtsearchstring_change.

The txtsearchstring box is = to the client_id on the main form.

Basically when the user clicks on the next record button (which is on the main form) it should update the txtsearchstring_change on the subform and then display the new results in the list box.

Im not to sure how to do this. I understand im calling a sub from another form, so i did try a public not a private sub. And i have added on the next and previous button - txtsearchstring_change.

Thanks for any help.

View 2 Replies View Related

List Box Data To Subform

Jan 7, 2005

Hi

how do i click on my data in a list box (4 fields unbound)) on my (main form) so that it goes straight to my subform fields (same 4 fields from the list box), this will save me on data entry and i can just enter my quantity and it will calculate a total for me.

i don't want a combo box in my field on the subform.

any solution??

View 6 Replies View Related

List Boxes With Subform

Jun 13, 2005

I am having the same problem as some others.
I have 2 cascade combo boxes
When I select CD Group and CD NAme they display the related values in a list box that's fine.

ex. CD Group Mormon Tabernacle Chior
CD Name displays cdnames with that Group.
NOW After I click cdnames I want it to go to that record on the subform which is cdtracks so it only displays cdtracks with that record.

The other problem is this might have to be straightened out is when I select a cdgroup and or cdname value it displays that value for all the records.
email mikevds@optonline.net so I can send you a attatchment

View 2 Replies View Related

How To Make A List In A Subform

Jul 23, 2014

I am trying to build a training database, I want to open a form which shows the employees details, when open I want the attached Sub form to show a list of training documents completed to be listed. I have got it so that the sub form shows a list but of all the students, but I just want a list for the the specific person.

View 2 Replies View Related

Cd Author List Box Related To Subform

Jun 16, 2005

I have the folloowing tables in the database

tblCD/Main: CdID - autonumber, CDName - text ...anything else will be a lookup field that we will get from another table, so we will come back to this table

tblAuthorType - AuthorTypeID - autonumber, AuthorTypeName - text. author type name will have, as I see it, 3 types : Composer, Group, Artist.

tblAuthorName - AuthorNameID - autonumber, AuthorName - text, - the name of all authors, composers and artists that u will pick from later

When I select Author which can be a cdgroup which is fine it will display those cd's related to the cdname. Such as Author TypeName Composer, Group. Artist.
tblTrackNumber - -Name of Song TrackNumID - autonumber, TrackNum
I have a subform and I want it to go to the tbktrack number with Name of Song related to that CD after I select an Author from the list box.

I am fairly new to this I need the vb codes for modification
mikevds@optonline.net

I set up these tables so then the relationships will refer back to them.

View 1 Replies View Related

Puttin A Subform In A List Style?

Jan 10, 2006

Hi,

In the subform i have the layout i want with the text boxes and so on.

Now i have that in the main form the sub form is fairly big, but the problem i get is the subform only displays 1 record at a time. Is there a way i can get the subform to display all the records and for it just to add a verticle scroll bar.

So it is a list effect.

Thanks
k0r54

View 2 Replies View Related

Multi-color In List/subform/...

Jul 10, 2006

Hi all.

I have searched everywhere but I cannot find the anwser. I'll try to explane.

I have a table in ma database, to make it easier, let's call it Table1.

Table1:
Id,Name,Category

Now, In my form, I wanna see this table. I did it with a list, and that works perfect. Now, I want the next thing to happen:
If category = 1, then the backcolor of that record should be yellow
If category = 2, then the backcolor of that record should be green.

Now the problem is, how can I get multicoloring in my list? or in a subform?

Thx

View 4 Replies View Related

Modules & VBA :: Go To Record From List Box On Subform

Aug 12, 2014

My main form has a union query as it's record source. This displays a list of items for which the user uses this form to apply a category for each of the items. This relationship of item to category is stored in a temporary table. I have a subform with a list box that shows the current selections and is based on the temporary table. The linking of the master and child is based on the "description" field. I would like the user to be able to select one of the items in the list and have the main form go to that record. (the list box has multiselect set to none).

View 14 Replies View Related

Forms :: Black List For A Subform?

Oct 14, 2013

I want to create a black list for a subform

For example,when I enter a number to the subform,if the number be in blacklist,it become red color!

View 1 Replies View Related

Subform Within Form Containing Drop Down List

Apr 5, 2014

I've been trying to create a subform within a form with the subform having a drop down list. Once I have that figured out I will be adding another level (another subform with drop down list within the subform already mentioned).

I am able to create the subform with the form but I'm having trouble with the drop down list. I will explain what I am after with an example.

Form - contains models of vehicles (Jetta, GTI, Golf, Passat, Touareg, Tiguan, etc...)
Subform 1 - contains tranmission type (automatic, manual, tiptronic, paddle)
Subform 2 - contains vehicle color (red, white, black, blue, green)

I would like to use the form described as a way to input all the vehicle variations as they are needed. Then it would be desirable to use that information on an another form.

Another form, an Order form would then use the vehicle variations. The user would select the model of vehicle and in the drop down for transmission type would only see the available selections based based on the variations built above. Likewise, once transmission type is selected, the colors available would be shown in a drop down list, but only the colours available for that particular vehicle and transmission combination.

The above is a simplified example. The real application for this method will be a product line that will contain over 150 styles, with variations in appearance and colour.

View 14 Replies View Related

Dropdown List

Jan 23, 2006

Hi all,

I am very new to Microsoft Access, and hope somebody can help me. Apologies for what I am sure is an easy subject - but I dont know what keywords to search on!

Basically, I need to have a drop list of say 5 different products. Now depending on the product will lead to different field boxes (say each product has 15 fields, 10 which are the same, but 5 which are unique to each product). I basically want the form to change dependent upon the product type. As I say I am very sketchy on this, so feel free to treat my like an idiot! If anyone could give me a hint as to what help topic this relates to, or give me a brief overview of what to do, that would be very much appreciated. The information will be downloaded from an ODBC if that makes any difference.

Many thanks in advance

Mike

View 2 Replies View Related

Dropdown List

Dec 3, 2006

Hi,

I create a dropdown list, which has 3 columns with column heads.

Can we set Bold format on the column heads?

Thanks.

View 1 Replies View Related







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