Search results

Hi all, Is it possible to use the result of a query to update a field in a Table. I keep getting an error - "operation must use an updateable query". Any help appreciated. rgs Ginny:(

Looks good, but could you show me an example of it running a query with the option chosen. I'm whacked - so I mightn't get back to this tonight. rgs Ginny

Ken, I have a global variable set up as GBL_paCode. In my Forms OnOpen Event I have set the variable to the "ComboBoxName". In all of my queries I have used the Criteria 'get_Global("GBL_paCode")'. GBL_paCode takes each of the variables separately, but I cannot find a way to pass "All" to it...

Hi Ken, thanks for that. Yes, I can get that far. I now have 'All' or '*' in my option list, and I am presuming that this is now set as my variable, but how do I get this to pull back my data when I run the form? I get nothing ! ! When I use '*' in my queries (manually), all data gets pulled...

It's linked to a query, which pulls distinct values from a table. Thank you for your reply.

Can anyone point me to where I might get help setting the above up. I have a list of unique enties in a query, and have set up a global variable so that on my form when I choose an option from the list only data relating to that option is pulled back from a number of tables/queries and output...

Thank you, - problem solved. Complete newbie here, this forum is great and I appreciate the help. Ginny

Hi all, help with this would be appreciated. I have a crosstab query which returns values in a range of categories. I have 5 categories. My problem is that sometimes a category may not return a value in 1 or more of the categories. This means that when I am displaying this data in my report...