Search results

Sorry Paul - I removed most of the code I tried. I will try again and see what happens. If I still can't get it to work I will post the code I am using.

Hi - I have attached the DB here because I am not having much luck. If you go to KZ search and type "price" in the text search there will be 2 results displayed in the subform. They are both the same record but are displaying as 2 but I understand why that is happening (because they have two...

Paul - sorry I may be confusing you. I load a form with a search box and the user enters, for example "printer" the subform then populates with all records from a table that include the word "printer" somewhere in the description. I then want the user to be able to select a record from the...

Thanks for the quick response (your next one might not be as quick!). I can open the form and get the right record to display the problem is getting the correct reference from the subform. I can't seem to get the subform to tell me what the first column of the selected records value is. I...

I have a main form "KZ_SEARCH" and within this I have a subform which is loaded when a button is pressed and is populated with query results (based on text entered in a text box). The subform is called "KZ NOTICES Query subform". That all works fine and the query modifies based on the text...

I have a form with a button which then shows a popup form. The popup form is just to list customers and their respective customer numbers and is not relevant to the base form that the button resides on (as in there is no common data). When the popup form loads it has a textbox where the user...

Panic over - I set the datasource of the subform to "" via an expression before running the rest of the Macro. Works fine now.

I have a drop down box on a form that, dependent on what is chosen runs a query which creates a new table ("POWER PRICES Query Table 1") via a Macro. It then displays the results in a sub-form. If you then use the drop down box again to change the selection I get the error message "The...

Paul - I have done this now with an update table query which updates the form source table so it now shows correctly in the form. I don't know why the Column(2) wasn't working as all set up fine but I have managed to get round it now. Thanks for all your help and advice. Fiona.

Yes Paul it is 3 and all 3 show when viewing the table.

Paul - unfortunately none of these combinations have worked. I found something on the web about using columns and this worked well for one of my fields. In the table I did a combo box which showed the customer number the customer name and whether they were cancelling. The customer number was...

It may be my missunderstanding but the answer I want isn't from a form it is to go in to a form. I am saying that the NAD_NUMBER in my current form is the same as the NAD_NUMBER in the table CONTRACT NAMES AND NUMBERS. The syntax in the reference doc seems to point to the target being another...

Thanks Paul - when OKing this it gives me: =DLookUp("[REDUCED_USERS]","[CONTRACT NAMES AND NUMBERS]","[NAD_NUMBER]=[CONTRACT NAMES AND NUMBERS]![NAD_NUMBER]") However this still does not work. I am expecting that if the tick box is ticked in the CONTRACT NAMES AND NUMBERS table it will show...

Hi - I am not very adept at Access but have put together some tables, queries and forms and have, so far managed to get by. I have come to something which should be really simple but I am struggling. 1. I have a table called "CONTRACT NAMES AND NUMBERS" with a field called "REDUCED_USERS"...