I have a query-based combo box on my form. The field is the ClientCoID which is a foreign key and is long integer. My Row Source is: SELECT...

I have an unbound text box in a subform which is one of 4 subforms on my form - all of which have a one-to-one relationship. I am using the DLookup function...

I have a pretty long piece of code that I'd like to space out over multiple lines for easier reading and future handling and I know I've seen a special

I need to use the chosen items in a multi-select List Box as concatenated text in another control on a subform. This text will be part of a large amount of...

I have a form with 5 subforms nested inside each other. I am getting it to tab from subform1 to subform 2, but when it does, the 2 controls on subform1...

I need to use the chosen items in a multi-select List Box as concatenated text in another control on a subform. This text will be part of a large amount of...

I'd like to create a command button that will copy the data from a control on my form for the user to then paste in whatever other various application (MS or...

I have a control that is to display in the On Enter event, a concatenated sentence including the users choices in a multi-select list box. The code is...

I have a multi-select List Box on my form. Is there a way for the user to Deselect All if they make a mistake and click on an Item in the box? I just made...

I have a large amount of text to concatentate and Dlookup that I want then displayed in an unbound text box on my form. I am not being able to get any text...

In my form, I have a set of 3 list boxes that have the multi-select option turned on. I would like to have some kind of box open when the user is in these...

How can I have the items that are added to my combo box add to the list in alphebetical order? I currently have it coded to be able to add item on NotInList...

I have cboAdjusterID on a data entry form, frmClaim, with NotInList event that opens frmAdjuster. When the event fires, I would like to have the system auto...

I have cboAdjusterID on frmClaim that opens frmAdjuster on the NotInList event to add the new entry. Someone here helped me with the code but now I'm...

I have a data entry form, frmClaimAssignment, with cboLossType. On the AfterUpdate event of this combo box, I have code to open frmInterestedParty as a pop...

I have sfrmInspLoc based on tblInspLoc and apparently the table doesn't update as fast as necessary to handle a popup form, pfrmInspLocRep, with the OpenArgs...

I have a command button on FormA to open FormB. The OpenArgs property for this button on FormA is set to Me!AssignmentID. On the OnLoad event of FormB, I...

I've found in an Access help book some sample code for the DLookup function and now I'm trying it out but getting a syntax error. The exact error...

I have created a work queue form based off of a query for all of our in-progess cases. The results may easily exceed 250 records and for easier navigation,...

I have an unbound text box on my switchboard into which users put criteria which is then used to find the corresponding records. When the OnClick event of...