I want a way to allow the user to open a form and display a specific record...what is the easiest way to do this - my user is VERY novice and needs it to be...

I have a code that I've copied and used several times but it isn't working in this one instance. The control to which this is attached is on a subform...

I have a text box that I'm using, although hidden from the user, to Dlookup and Concatenate text from all the various entries on my form/subforms. Is there...

I am getting a syntax error that there's a missing operator in query expression 'ShopID ='. From this it almost seems that it isn't reading the True...

I am getting a syntax error on this code. The code is intended to check that the user entered data into the Remarks field if they also selected the text that...

I have a cbo ShopName on my subform that is populated by ltblShop. I want the the field blank if a ShopName is not applicable as this entry is later used...

I have a Remarks section in my form for the user to type any additional info pertinent to the file they are entering but it seems that about half of the...

I have a DLookup expression in my query that I want to return the corresponding description (text) for a given ID (Autonumber, pk) in the query. My...

To make my form a little more dynamic for each entry the user inputs, I decided to add cboVehicleType to my form which, when updated, requeries...

I have a cbo ShopName on my subform which is populated by ltblShop. The cbo displays the Name, but is bound by the ShopID. If the user doesn't enter a...

To prevent date mistyping of the new year, I'd like code to run on the AfterUpdate event of my DateInspected control if the user accidentally inputs a date...

In reading other posts on this issue, I added a hidden, unbound text box to subform1 that moves focus to subform2. Upon tabbing from the last field in the...

I have a fairly long code that I'd like to space out over multiple lines for easier reading and future handling. I know I've seen a code that tells the...

Another helpful person here gave me a sample, untested code to try to concatenate List Box Multi-Selections into a sentence. I've tweaked it a bit to attach...

I have a text box that takes the entries from a multi-select list box and concatenates them. My code is not reading that there is supposed to be a comma and...

I have an cmd button on my switchboard that opens a form based on criteria from a text box on my switchboard. I have 4 nested subforms on my form and while...

Some of my users are naturally using a back tab (Shift + Tab) to back up to a previous control where they may have made a mistake or tabbed to quickly over...

I have a command button on my Main Form that is supposed to, on the OnClick Event, set focus to a control on a subform and copy its contents and then close...

I have a message box that I want to display in the OnEnter event of a List box simply to give instructions as to how the user is to enter the info. My code...

I am getting an error message that indicates that Access is still trying to perform the DLookup or "False" when the result should be "True". Here is my...