Recent content by sandrothaver

Appreciate the advice! Thanks! ;)

My sympathies to you on your loss...some appropriate words...: The Greatest Art Henry David Thoreau, the nineteenth century writer, naturalist and philosopher, said: “It is something to be able to paint a particular picture, or to carve a statue, and so to make a few objects beautiful; but...

Ahh! Stupid me! It works now. Thanks very much for your time!:D

Hi I've done that. Please see code below. In the form, when I click on 'Amajuba', the text dissplays in the District field, but when i click on the rest - from eThekwini to zululand, numbers 2 to 11 dissplays in the district field. Seems like a minor problem with the code?? Private Sub...

Don't know what you mean. I'm very new to code.

Hi Khawar I've been trying Sample 2 and I'm almost there. I still get numbers but I think I'm close. Please check the code below for me and tell me why I still get numbers. I've adapted the Gender example for another one. I want to display the 11 names shown below in my query. Thanks!:)...

Please give me an example of the code I would have to use ie. 'if' statement. If the checkbox is unbound on the form, how will it store the text values in the gender field?

So using an option group with control source being the field 'gender' will give me 'male' and 'female' values in my gender field for the query, instead of numbers cos that's the problem?

I've tried an option group, but have the same problem when querying -male and female are listed as separate fields with numbers as values.

Hi! I have checkboxes for MALE and FEMALE (my form has to mirror my data collection form, hence no drop-downs). What code do I put behind the checkboxes to allow the query to reflect the values in one GENDER field (which I will create in the table with drop-downs) with the actual values - male...

Works Neil. Thanks mate!

Thanks Neil, I've got this one working now. How would I add another after update to this event? I would like to make another subsequent field null but on a different entry in the cadre field...do I just go AND...???

Option groups We have a winner!!:D Bit weird though...in the other d/base, I didn't use brackets of any kind and it worked! Thanks Ken!

option groups Tried that...I then get the Number assistive devices.. highlighted with this error message: Compile error: Syntax error

Option groups You're absolutely right. The forum is very useful but has its limitations. I have played around with some code. Can you tell me what's wrong with the code below...its designed to make a subsequent field disappear after update. The code has worked for me in one d/base but is not...