Search results

Where is this code? In what form?

Actually I don't think you can use the (Form_) syntax in the Forms collection. If the name of the form in "Questions" then the syntax would be "Forms!Questions.Controls("A" & i)"

The syntax will be something like: Forms![Form_Questions].Controls("A" & i) Is this executing on the same form as the controls?

Concatenated together?

Is this loop executing in the Form_Questions Form? Where do you plan to place the returned values?

The output of the Format() function is always a String.

Try using the "&" as a concatenation character instead of the "+".

I asked the Mods for assistance on this so they may know someone with 64 bit Access.

We'll have to wait for someone with 64 bit Access then. I can't test it as I have 32 bit Access. Sorry.

Would I be correct in assuming you are using a 64 bit Access?

This link may help: http://theaccessweb.com/forms/frm0031.htm FYI, all controls on tab controls have unique names and you reference them as if the tab control was not even there.

I'll bet it is a string value so enclose with single quotes: =DLookUp("[EmpInitials]","tblEmployees","[EmpName] ='" & [Forms]![frmLogon]![txtUserName] & "'")

Have you done a Compact and Repair yet?

You have undoubtedly figured out that SubForms are *not* listed in the Forms collection.

Perhaps this link will help: http://theaccessweb.com/forms/frm0031.htm

You probably do not want to hear this but when I see table descriptions like: ""EmplJobs" is a simple table with 7 fields: EmployeeID, JobCode, JobeCode1, JobCode2... thru JobCode5" alarms start going off about normalization. You may have an issue with your design that may make every task just...

A big WELCOME from this side of the "pond"! ;)

We welcome you and your bad habits and will endeavor to help you make the adjustments. :) Seriously, glad to have you on board. ;)

Just use Galaxiom's solution.

Queries eliminate a lot of Locked Table issues. Give it a try.