Search results

I agree. The Yes/No field serves no purpose.

Suggest that you take a look at "Conditional formatting" of your control on the form

Cross-posted: https://www.accessforums.net/showthread.php?t=89178 Please read: https://excelguru.ca/a-message-to-forum-cross-posters/

Try: Private Sub Clear_Investigate_Yes_Click() ' Fuction Name ===> In the field Investigate, Change "Yes" => "No" ' Table Name ==> update Investments01_tbl ' Field Name ==> investigate ' Change Data in Field Investigate, from Yes to No ''CurrentDb.Execute "update Investments01_tbl" & _ '' "set...

Thank you for your kind wishes. I hope you have a great Christmas and New Year too!

You're welcome. Always pleased to help i I can :)

Try changing the "Triple State" property of each radio button to No

Not often do I get cold and frosty reception here :ROFLMAO: Happy Christmas Jon and everyone.

So, I repeat, have you checked the "Name" property setting and the "Source Object" property setting of the control being used to hold the subform. The "Name" property setting can be found on the tab called "Other" on the Property Sheet and the "Source Object" property setting can be found on...

Have you checked the "Name" property setting and the "Source Object" property setting of the control being used to hold the subform.

I think it can be difficult/misleading to generalize but I wouldn't say that was true of the UK. Perhaps another good reason for us not being in Europe ;)

Sounds like an interesting project ;)

Welcome to the forums :) What does the "RC" stand for in "RC hobby" ??

If both B and C are opened, using the acDialog argument, then whichever is opened last should stay "On Top". Double-check that you did set the acDialog argument of DoCmd.OpenForm when opening both B and C.

Ah! They don't call me "tinkle-toes" either. Full Stop!!

Probably not as well as you :ROFLMAO:

Post a copy of your db

Is that the only event that isn't working? Is the event property set to [Event Procedure]

Is your db split, with each user having their own front-end and each front-end linked to tables in a single back-end file?

Without wishing to be pedantic and for the sake of that clarity, what you have said is correct but take the following into account: If the body that issues a cert were to change the length of time a cert is valid for from, then you would need to create a new entry in "CertListT" rather than edit...