Search results

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...

Sorry Cronk, I didn't see your reply in your original post - thank you.

Thanks for the replies all. I now have some of it working. By that I mean I can choose a timeslot using any one of the toggle buttons to essentially assign it to a country. This enters the following values into tbl_allocatedtimeslots: - The countryID - The time itself (in text format) What...

Apologies, I should have been a little bit more specific but I didn't think it was relevant. I do have all of the countries and then there are some other entries added to the list. Organisations and other entities. Essentially they're all one and the same thing for the purposes of the...

Indeed. It doesn't look too pretty at the moment and is a little funny on the eyes. I just have a block of 6 x 19 toggle buttons! :D I'll keep building. Cheers

Thank you very much for the replies. I will take a look at the attached files and crack on with trying to get this done! Thanks again. David