From: Dirk Goldgar on 18 May 2010 18:15
"KSmith" <KSmith(a)discussions.microsoft.com> wrote in message
>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.
What spaces are you talking about? I don't see any superfluous spaces in
what you posted here. Please post the revised statement that seems to work.
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html
(please reply to the newsgroup)
From: KSmith on 25 May 2010 09:20
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. But I still don't understand why
that corrected the problem.
I have another problem that I will post.
And thank you for all of your help.
"Dirk Goldgar" wrote:
> "KSmith" <KSmith(a)discussions.microsoft.com> wrote in message
> > RouterID is the first field in tblRouterArea TABLE
> > RouterID is the first field in the Forms Record Source: Select Statement
> > RouterID is the first field in the ComboBox Row Source: Select Statement
> > Bound Column is set to 1
> > "Dirk Goldgar" wrote:
> >> "KSmith" <KSmith(a)discussions.microsoft.com> wrote in message
> >> news:3A43B827-F243-41DC-B63D-3F077AB267F4(a)microsoft.com...
> >> >
> >> > Set rs = Me.Recordset.Clone
> >> > rs.FindFirst "[RouterID_tblRouterArea] = " &
> >> > Str(Nz(Me![cboMaterialLookUp], 0))
> >> In addition to the code changes suggested by mie, verify that the form's
> >> recordsource actually contains a field named "RouterID_tblRouterArea".
> >> I'm
> >> guessing that it doesn't.
> If "RouterID" is the name of the field, then why are you looking for
> "[RouterID_tblRouterArea]"? Your .FindFirst statement ought to be just:
> rs.FindFirst "RouterID = " & Nz(Me![cboMaterialLookUp], 0)
> If that doesn't work, then either RouterID is not a numeric field (which you
> have implied that it is), or you have misinformed us about something, and
> will need to post the exact SQL of the form's RecordSouce to help us figure
> it out.
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
> (please reply to the newsgroup)