Prev: Change Forecolor based upon if statement
Next: Populate date to another
From: KSmith on 25 May 2010 09:16
Thanks for responding to my problem. Sorry for the long delay in getting
back, I had a death in the family.

The "spaces" were not the problem, as you said. To solve this problem I
looked back over my notes and found that I created the first form as a
columnar form with the widzard. I made a new columnar form with the same
tables as my problem form. I then copied the Record Source line from the
newly made form to the Record Source line in the problem second form.

This corrected the problem I was having.

I have another problem that I will post.

And thank you for all of your help.
--
KSmith


"Marshall Barton" wrote:

> KSmith wrote:
>
> >I solved the problem, kinda. I removed some of the spaces that were in the
> >middle of the FindFirst line of code, and it Ran like it should.
> >
> >Now the spaces are in the code that I copied from. I am new at this and I
> >don't have all of my procedures in a module, they are attached to the forms.
> >
> >Wonder why the spaces are a problem in one place but not in another?
>
>
> What spaces? I don't see any extra spaces in what you
> posted/
>
> Extra spaces are ignored between operands and operators in
> VBA statements and several other places. They can be
> critical in names and quotes strings.
>
> --
> Marsh
> MVP [MS Access]
> .
>
First  |  Prev  | 
Pages: 1 2 3
Prev: Change Forecolor based upon if statement
Next: Populate date to another