Search results for query: *

Got it. Thanks for your help.

The Report Source is the original table, t_NEW_xxxs which is in the white space to the left of the [...]. When I click the [...], I get a new window that is asking if I want to create a query based on a table.

The original reports Record Source is a table that had all the data I originally needed. I created a new table that contains the lookup name and the new field that I want to add to the report. After I created the join for the original table to the new table, I tried to add the new Source_Name...

I created a relationship/join between the two tables. Then in the report for Text32 opened the properties but still did not see Source Name in the drop down list for Control Source. Maybe I'm just not understanding the suggestion.

I created a report from a table and it is working fine. I have a field in the report header called “Source” and now I need to add a field in that header based on the value in the header field “Source”. The new report field is called “Text32”. I created a table, “Source_Name” that has two...

Thanks so much! The proper sequencing worked like a charm.

I have a VBA module that populates controls in an unbound form with data from a table. The module then opens the form which also contains a visible/enabled command button (Command1)that the user clicks to send selected lines from the form (user clicks check boxes to indicate which lines)back to...

Sorry that I missed your suggestion in the earlier post because that is the answer. Thank you so much for working with me and your patience.

No, I don't pass the form object as a parameter. I run the module and open the form in the code with a DoCmd.OpenForm. Is my technique incorrect for Access? My background is mainframe, Cobol, CICS and we would define the first line on the form and then use an OCCURS clause to repeat it on the...

Correct my code is not in the form module. I is a standalone module.

Thanks, but I tried that and receive an error using "me".

I have a form with rows of data that I want to process one field at a time. When I built the form each field is assigned a sequential "Textxx" number e.g. Text1, Text2, Text3, etc. The form and fields are not bound and the form is populated by running a VBA module that retrieves the data...

So, I tried radio, toggle, and command buttons with the same result. I guess I'll need to just create a text box and control it programmatically.

Have a form that lists rows from a table; one row per form. Set form to continuous so multiple rows appears on a page. Put a check box to left of data from table to allow user to pick rows from the list to process/not process in the next step. Problem: when I click any one of the check boxes...

I want to run an SQL Select query in VBA to fetch one field in a row from the table using the primary key in the WHERE clause then perform an validation as to whether the Select found the record or didn't find the record. Is there a simple If statement I can use to perform the validation...