Search results

The only way a record shows in the query is when I advance to the next record (new record), then back to the previous record on the form. Is this the way that it suppose to work ? I wanted to retrieve the current record on the form without saving (i.e. advancing to the next record).

I created a new database ("Database3") and the same thing happens. See attachment.:banghead:

1. The data is in the form that I'm trying to retrieve 2. No error codes returned 3. The form, table, query, or report does not appear to be corrupted. How can I tell ?

Yes, I can retrieve all records from the table without the filter. Here is the SQL code: SELECT Spiritual_Gift_Totals.Survey_Taker_First_Name, Spiritual_Gift_Totals.Survey_Taker_Middle_Name, Spiritual_Gift_Totals.Survey_Taker_Last_Name, Spiritual_Gift_Totals.Leadership...

I thought I gave everything that is needed in my opening request. I'm using a query to retrieve a data field in a form. This query criteria is [Forms]![Questions]![Last_Name]. I also tried CStr([Forms]![Questions]![Last_Name]). The field definition in the table is "Short Text". The form is open...

That is, the current record on the form.

Thanks . . . No record(s) are displayed.

I would appreciate it if someone could tell me where to look for the resolution of this problem.

Any hints on resolving this failure ?

Can somone tell me what is wrong with my attempt to retrieve of a value (Last_Name) from an open form (Questions) to a query ? Form name is Questions Form field name is Last_Name This query criteria is [Forms]![Questions]![Last_Name]. I also tried CStr([Forms]![Questions]![Last_Name]). The...

Whoops . . . I see my mistake. Thanks ! ! !

Now I'm getting a return of "False". See code below i = 0 Do While i < 3 i = i + 1 Aout = Me.Controls("A" & i) MsgBox Aout = Aout & i Loop End

The code is part of a form (i.e. "Form_Questions"). The textbox are "A1" through "A80". This form is a survey and I'm trying to loop through the answers from the survey with VBA.

This did not work either. Do I have to change the form name (i.e. "Form_Questions") to something else ?

I tried that . . . I just get the text value, but not the value of the testbox. Aout = "Forms![Form_Questions]!" & "[A" & i & "]"

In a VBA variable

How can I create a loop to retrieve the value of multiple textboxes ? For example "A1" would become "A2" . . . "A55". I would then retrieve and display the value of the textbox. The below syntax will display the value of my form "Form_Questions" and textbox "A1":banghead...

Brian, I calculated the overdue in the query (i.e. subtracted 'End_Date from 'Due_Date'). Thanks for the information ! ! ! :o

I have a table with three (3) dates. The dates are 'Start_Date', 'End_Date' and 'Due_Date'. I want calculate the difference between 'End_Date' and 'Due_Date' in number of days in a query. Can this be done in a query ?

Thanks to everyone who responded ! ! ! I already applied Jraw's solution and it worked fine.