Search results

Did you read the link I gave you regarding the use of lookups in tables? You should be using a combo on a form to "Lookup" the PK of required record and then store that PK in your record.

After making my last post, I notice that June has already mentioned some of the things that I commented on.

Take a look at the attached db. I have used your existing tables to create some new forms that may be more appropriate for your needs. I notice that you have a "Lookup" field called "What" in the table "TransTLB" which I would advise against. See...

Please post a copy of the db. Compact and repair it, then zip it and attach the zip file to your next post.

Hi Bungwaa Welcome to the forum :) I'm sure that you will find many here that are willing to help. Pleased to hear that your needs will likely be fulfilled in less than 20 years....I don't think I'll live that long :ROFLMAO::ROFLMAO::ROFLMAO: Perhaps you could start a new thread with...

June, can I ask if you have ever bought from Helpful Downloads and if so, how was the experience?

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.