Search results

Thank you but it still doesn't appear to be working. It says it's expecting an expression after the first equals sign and not the word select. My code is: cboCause.RowSource=Select Distinct Navigation.Cause from Navigation Where Navigation.Claim type=cboClaimType.Value order by...

Hi guys I'm creating a database where there will be multiple combo boxes on a form. When a user chooses an option from the first combo box, I want the available choices in the 2nd combo box to be reduced and so on. I thought I'd create a navigation table so the first column has multiple...

JonK Sorry, Can't get either to open or your suggested extra fields to work. However in a seperate query I ask the user to enter either 'Denials' or 'Refusals' and the IIf statement converts it to look in the table for 'PD' or 'PR' so I can't understand why that's working and not the first...

JonK Your attachment doesn't unzip my end as it appears to be an archive file. I didn't fully understand the message. Are you saying I should have a seperate column in my query for each of the 7 lookups where a TRUE response will appear if the user has chosen 'All'. If so, how would I then...

Guys I have a database table with approx. 20 fields of which I want users to be able to choose from 7 of them. I've created lookup tables to enable dropdowns in a form and then a command button to open a query where the search criteria is populated from the chosen options on the form. However...