Recurring problem with conditions...

[HenHouse]

Hi folks;
Bit of an intangible problem this, I'm not sure if there's to simple a solution out there. I have a couple of tables represented by a couple of forms, and I want a checkbox on master form A to go "Yes" if (and only if) a particular text value in a drop-down box on sub-form B is selected.

At the moment I'm doing it by using a simple SetValue macro in the After Update property of the text box on form B. Having it on After Update isn't ideal because it doesn't always stick.

So here's the question - is there a way of declaring some kind of global condition in Access that says "if formB!ValueX="text" then FormA!ValueY=Yes" No more depending on After Update, On Load or After Render, just a simple declaration tucked away in the backgrund. I imagine one could do it with VB or SQL but I don't really know either of them. If there's a simpler way, does anyone know it?

Thanks!

[Rabbit]

If the checkbox is an unbound control then you can use the control source to populate the checkbox. If not then you'll need code, if After Update isn't working all the time, then use On Change.

[HenHouse]

Unfortunately the checkboxes are bound to a control already. how much code would be required do you think? I need to bite the bullet and get a bit more familiar with it anyway...

[Rabbit]

You won't have to do much, whatever you're using in the After Update, use it in the On Change event instead.

[HenHouse]

Cheers guys, I'll try that and see if it works!

[HenHouse]

In the end I just put together a few update queries that run on startup and ensure everything's in order. Maybe one day I'll learn VB and I can stop doing it all the point-and-click way...

Cheers guys!

[Rabbit]

In the end I just put together a few update queries that run on startup and ensure everything's in order. Maybe one day I'll learn VB and I can stop doing it all the point-and-click way...

Cheers guys!

Glad you got it working, good luck.