Search results

Gents, thanks for your input. Will have a go over the next couple of days & let you know how i get on.

Gents, thanks for the prompt replies. I figured what @arnelgp deduced. @arnelgp do you know of a demo database that displays this technique? Appreciate your help as always.

Friends, So I have a combobox 'ContactPurpose' on a bound continuous subform. I wish to populate the combobox with all records except when the user enters a new record, in which case I wish to restrict their selection to only 'Active' records. So, i have 2 select queries as below on the...

@arnelgp , Thanks. It's that simple...I continue...

Friends, I intend to use 'modNotInList' to manage user additions to comboboxes. I did not write this code, but cannot remember where it came from!. I have a form 'frmOrganisations' on which is a combobox 'OrganisationCategoryID'. My intention is for the user to add a unique additional Category...

Went with @Edgar_ recommendation works fine. Appreciate it. The project continues......

Gents, thanks. Will let you know.

'Hi, on 'tblOrganisations', I have a tabbed 'subform' on tab 'Personal' of that subform is a combobox 'cboClassification' that I wish to update whenever a user selects the button 'BttnOpenCategory_Jobs' on the main form. This opens up form 'frmOrganisationCategory_JobRoles' , checks that...

Gents, cheers. I will take my time to digest this. I move on.....

@MajP , I like your code & will adopt it for my other forms, nice & tight (if that's a way to describe code!). My only gripe, is how does an amateur like me learn these tricks? I got a working copy using tempvars, but your technique is so much cleaner. Thanks again

@MajP , thanks a lot. I got a version running too & will have a look at your example. I've never had a need to open multiple instances of a form before. It's a clever/powerful technique but not covered very well. My philosophy is that if i'm not happy with my coding then don't settle for it. It...

@MajP, will do. I've already had success by deleting all openargs & saving the form description (new, amend or drilldown) as tempvars. Will make a version with your code too. Thanks to all for the effort.

@June7 , you hit the nail on the head in post #5. Exactly my observations. I don't understand why the openargs value is not nulled by opening the second instance, but is nulled for subsequent instances. Will have a go using tempvars instead of openargs. That way at least i can null the tempvars...

@June7 , i concluded same but could not figure why. All forms opened with the hyperlink should not display the nav buttons or record counter (after all only a single record is opened), also should display a different caption to those opened by either menu option on frmMain. I'd expected that...

Hi, I'm working on my CRM project. I have a problem where the wrong fields are hidden/displayed upon initial opening of the next form after the initial form is opened. Difficult to explain, but open frmMain, open either of the top two options & the correct controls are displayed (that is Nav...

@Pat Hartman , Thanks. Will watch the video & have a look at the database.

All fixed. Using Before_Update event to validate data & if validated successfully, using if me.newrecord to run the code to make the new record in frmParty, then using the dmax to find the max partyID PK which is then saved as either frmPerson or frmOrganisation PK. Thanks to those whom...

All, got it sorted. Using Before_Update to validate data & if me.newrecord to add Fk. Will have a go with Before_Insert as an alternative approach to the if me.newrecord in the Before_Update event. Took me while to get my head round these important events. Thanks for the comprehensive answers.

@jdraw, I saw that too. See post #26. My Bad!

Didn't Upload. See attached