Search results

What is the out come of this thread because I have a similar problem. What I try to achieve is when the user makes a selection from a combo box "LoanDocListID", I need "RequestDate", a text box, can't be blank. I achieve so, I insert following code in the on change event, unfortunately nothing...

Now, I am trying to give a default value for "RequestDate" field based on selection from the list box. I attempted with few variation, but none of them work. Please advise what did I do wrong(in blue). Private Sub List38_DblClick(Cancel As Integer) DoCmd.OpenForm "F_LoanDocuments", , ...

Hello, The SQL query shown below is for a list box in a form, I added a WHERE condition (in red) to the statement to filter records in the list box that matched to LoanInfoID of the form. I am getting an error message that state: "Syntax error (missing operator) in query expression...

It is working, THANK YOU ALL, THANK YOU, THANK YOU…! I thought Excel was cool, but Access is even better and again thank you! Van

Including the hidden/invisible one, RequestDate would be would in column number 2. There are 3 columns in total. Thanks for your help! Van

Thanks Paul for getting back, unfortunately I am still getting the same error. Please see attached. Regards, Van

How to add second criteria to OpenForm function? Basically, I need help with double click VBA code event in a ListBox. I two related forms, in the primary form contain a listbox, when user double click on a specific record, the second form will open and should filter record based on 2 criteria...

It works, thank you! Van

Hello, I am learning Access and need help with a query for a list box using table below. I am trying to create a query that generate only RequestDate and TransactionType that do not repeat. The targeted result would look like: 2/5/2012 new 3/3/2012 modification 4/1/2012 renewal Is that...