Recent content by Chumpalot

Thank you for this. Would this go in the On Load event for the form?

Thanks, I'll give this a go also.

Apologies, I missed that. You're right, I could. I'm going to have a play around and see what I can come up with. I'm very much a dabbler when it comes to Access and so some of the basic concepts are alien to me. I usually get by by tinkering and some trial and error.

I understand all that but have no idea on how to actually construct the IF statement on the Combobox.

There are 190 odd countries + around 100 organisations and companies.

Thank you for this. This all made sense until you started talking about bit positions! I think I can probably just about get away with using the Tag property but I will definitely look this up. Cheers.

Thanks for the reply. Yes, I have this table already although each country/organisation has only have one value assigned to it (between 1 and 10). These values would then dictate which groups to show/hide. My problem is I have no idea how to code it! I guess I'm looking at the AfterUpdate...

Morning everyone, Despite a fair few searches I've not been able to find the answer to a problem I'm having. I have a combobox with a list of countries (around 300 values). These countries all have a value between 1 and 10 depending on what status they have. On the same form is a subform with...

I managed to get this working. I changed both bound columns in tbl_CountryGuestTypes to 2 instead of 1 and now the text values are being pulled through rather than the ID. I realise it's not best practices to use lookups in a table but this has given me a better understanding on how to...

Morning all, I am close (I think) to getting this working. I am using the following code in the on load event of the form the combo box is on Private Sub Form_Load() Me.cbo_selectcguesttype.RowSource = "SELECT GuestType " & _ "FROM tbl_CountryGuestTypes " & _ "WHERE [CountryCategory] =...

I'll have to give it a go tomorrow as I only have access to my Macbook right now. Thanks again for your help.

Would I need to include the country table? Since the individual country data is handled elsewhere. Could something like this work? tbl_CountryGuestTypes ID, PK CountryGuestType, FK CountryCategoryID, FK Then my combobox would run off code similar to the following: ------------ Else...

This article explains things more clearer than I can and offers a solution for guest types associated to only one country category.

Hi theDBGuy and thanks for your reply. Yes, I think so too but my mind has drawn a blank on how to get this done. I know how to get it working if only one guest type relates to one country category but I need multiple guest types to be related to multiple categories. I am just not sure how...

Evening all, I have a combobox displaying guest types. The row source is from a table called 'tbl_guesttypes'. The values are: [PK] [GuestType] 1, Royals 2, Heads of State 3, Premiers 4, Governors 5, Heads of Department 6, Ambassadors 7, Prime...