Search results

Further to my earlier thread... e) once data is entered, i want the respective tblProject and tblPackage to be updated.

Basically I want to in [Form1]: a) select and filter a ProjectName via combo box [cboProject] via query [qryProjectCombo]; b) select and filter respective PackageName influenced by the selection of the ProjectName. This is done via combo box [cboPackage] and query [qryPackageCombo]; c)...

Thanks, however, I notice when selecting cboPackage criteria, the query does not subsequently filter that package, it maintains the filter to the cboProject criteria. I therefore created a second query on the result of the first query and linked cboPackage to the second query. This works, but...

Thanks. A bit cheeky I know...but I've attached my basic database (converted to verison 2003). I'm really stuck on selecting my filtered dropdown from the 2nd combo box [cboPackage] and running [qryPackageSelection]. I've tried the second criteria in this query against field [PackageName] but...

Mihail, I attach my simple database. As I say, I'm struggling with the selection of the 2nd combo box and the running of the query based on both combo boxes. Thanks for your assistance in advance, Steve.

Apologies. I mistakenly posted the first message under forms!

I have two combo boxes in a form. The 2nd combo box is influenced by the selection from the 1st combo box. The record source of the 1st combo box is a table and filters a query OK according to the parameter query I have written. The 2nd combo box correctly lists data influenced by the selection...

I have two combo boxes in a form. The 2nd combo box is influenced by the selection from the 1st combo box. The record source of the 1st combo box is a table and filters a query OK according to the parameter query I have written. The 2nd combo box correctly lists data influenced by the selection...

Thanks Pat...I've made progress via correcting the column count as you suggest from the query; however, I cannot select the packages from the second combo box. I've tried a second [Forms]![YourForm]![Yourcbo] criteria in the same query which initially filters the ProjectName, but when I do that...

Hi, The examples in the threads regarding related/cascade combo boxes generally relate to data direct from table, which I can follow. The issue I have is filtering data from a query ie. combo box is blank or reads #name? when setting the record source from a query. Basically, I want to select...

Thanks PR2-eugin for your prompt response. I generally follow the logic of the examples (I think) but I’m struggling a little applying the theory to my database as I’ve created a simple query [qryPackageSelection]. This query generally retrieves the key elements of the tables listed below...

Firstly, I would say my skill level falls between good beginner/early intermediate with no programming skills. I have a basic database with a [Project ID] table – with a one to many relationship with [Package ID] table which has a one to many relationship with [Instruction ID]. I have...

Hi I've reasonable good 'beginner' knowledge wanting to progress to a good intermediate level.