form is requesting parameters when not expected

[suttoh]

Hello,

I'm hoping someone can help me... I have a search form
in a contact database. When someone searches for a name
and the name appears in a listbox they should then be
able to doubleclick the name in that listbox and a more
detailed form is populated for that person. My
ondbleclick code for the listbox is:

Private Sub List22_DblClick(Cancel As Integer)

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Contact Detail"

stLinkCriteria = "[contactID]=" & Me![List22]
DoCmd.OpenForm stDocName, , , stLinkCriteria

End Sub

I recently changed the names of some of the fields in my
underlying source table and now when I doubleclick I am
getting requests to populate parameters. I know it has
to do with me changing the names, but I can't figure out
how to fix it. I need to keep the new names because they
need to match the data I'm automatically importing
regularly from a text file.

Help!!

Thanks!

 

[Wayne Morgan]

Did you go though and change the names everywhere? They will also need to be
changed in the query feeding the form and in the Control Source of the bound
controls in the form. Also, is [contactID] the new or old name?

 

[suttoh]

Contact ID is not one of the names that has changed, in
fact, it is the only one that did not change. The fields
that the params are requesting appear to be changed in
all the queries and on the form....

Any other thoughts?

Thanks.

-----Original Message-----
Did you go though and change the names everywhere? They will also need to be
changed in the query feeding the form and in the Control Source of the bound
controls in the form. Also, is [contactID] the new or old name?

--
Wayne Morgan
Microsoft Access MVP

Hello,

I'm hoping someone can help me... I have a search form
in a contact database. When someone searches for a name
and the name appears in a listbox they should then be
able to doubleclick the name in that listbox and a more
detailed form is populated for that person. My
ondbleclick code for the listbox is:

Private Sub List22_DblClick(Cancel As Integer)

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Contact Detail"

stLinkCriteria = "[contactID]=" & Me![List22]
DoCmd.OpenForm stDocName, , , stLinkCriteria

End Sub

I recently changed the names of some of the fields in my
underlying source table and now when I doubleclick I am
getting requests to populate parameters. I know it has
to do with me changing the names, but I can't figure out
how to fix it. I need to keep the new names because they
need to match the data I'm automatically importing
regularly from a text file.

Help!!

Thanks!

.

 

[Wayne Morgan]

There IS someplace you've missed, it's just a matter of finding it. Have you
used any of the field names being requested in calculated fields in the
query, as a calculation in the control source for a control on the form, or
in a SQL statement typed directly into the row source of a listbox or
combobox? If you have a subform(s) on this form, is it being used as a
Master/Child join link between the main form and a subform?

--
Wayne Morgan
Microsoft Access MVP

Contact ID is not one of the names that has changed, in
fact, it is the only one that did not change. The fields
that the params are requesting appear to be changed in
all the queries and on the form....

Any other thoughts?

Thanks.

-----Original Message-----
Did you go though and change the names everywhere? They will also need to be
changed in the query feeding the form and in the Control Source of the bound
controls in the form. Also, is [contactID] the new or old name?

--
Wayne Morgan
Microsoft Access MVP

Hello,

I'm hoping someone can help me... I have a search form
in a contact database. When someone searches for a name
and the name appears in a listbox they should then be
able to doubleclick the name in that listbox and a more
detailed form is populated for that person. My
ondbleclick code for the listbox is:

Private Sub List22_DblClick(Cancel As Integer)

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Contact Detail"

stLinkCriteria = "[contactID]=" & Me![List22]
DoCmd.OpenForm stDocName, , , stLinkCriteria

End Sub

I recently changed the names of some of the fields in my
underlying source table and now when I doubleclick I am
getting requests to populate parameters. I know it has
to do with me changing the names, but I can't figure out
how to fix it. I need to keep the new names because they
need to match the data I'm automatically importing
regularly from a text file.

Help!!

Thanks!

.

 

[suttoh]

I don't have to change label names do I?? I've changed
everything in all tables, forms, reports and I'm still
getting the param requests. I can't figure out what I am
missing...

-----Original Message-----
There IS someplace you've missed, it's just a matter of finding it. Have you
used any of the field names being requested in calculated fields in the
query, as a calculation in the control source for a control on the form, or
in a SQL statement typed directly into the row source of a listbox or
combobox? If you have a subform(s) on this form, is it being used as a
Master/Child join link between the main form and a subform?

--
Wayne Morgan
Microsoft Access MVP

Contact ID is not one of the names that has changed, in
fact, it is the only one that did not change. The fields
that the params are requesting appear to be changed in
all the queries and on the form....

Any other thoughts?

Thanks.

-----Original Message-----
Did you go though and change the names everywhere?

They
will also need to be

changed in the query feeding the form and in the

Control
Source of the bound

controls in the form. Also, is [contactID] the new or old name?

--
Wayne Morgan
Microsoft Access MVP


"suttoh" <[email protected]> wrote

in
message

Hello,

I'm hoping someone can help me... I have a search form
in a contact database. When someone searches for a name
and the name appears in a listbox they should then be
able to doubleclick the name in that listbox and a more
detailed form is populated for that person. My
ondbleclick code for the listbox is:

Private Sub List22_DblClick(Cancel As Integer)

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Contact Detail"

stLinkCriteria = "[contactID]=" & Me![List22]
DoCmd.OpenForm stDocName, , , stLinkCriteria

End Sub

I recently changed the names of some of the fields

in
my

underlying source table and now when I doubleclick I am
getting requests to populate parameters. I know it has
to do with me changing the names, but I can't figure out
how to fix it. I need to keep the new names because they
need to match the data I'm automatically importing
regularly from a text file.

Help!!

Thanks!


.

.

 

[Wayne Morgan]

No, you shouldn't have to change label name, they're not bound to anything.

Let's take it one step at a time. If you manually open the query feeding the
form do you get prompted? If so, the problem is probably in the query, if
not, it is further downstream (i.e. the form). If the problem is with a
report, did you check the Sorting and Grouping option?

--
Wayne Morgan
Microsoft Access MVP

I don't have to change label names do I?? I've changed
everything in all tables, forms, reports and I'm still
getting the param requests. I can't figure out what I am
missing...

-----Original Message-----
There IS someplace you've missed, it's just a matter of finding it. Have you
used any of the field names being requested in calculated fields in the
query, as a calculation in the control source for a control on the form, or
in a SQL statement typed directly into the row source of a listbox or
combobox? If you have a subform(s) on this form, is it being used as a
Master/Child join link between the main form and a subform?

--
Wayne Morgan
Microsoft Access MVP

Contact ID is not one of the names that has changed, in
fact, it is the only one that did not change. The fields
that the params are requesting appear to be changed in
all the queries and on the form....

Any other thoughts?

Thanks.

-----Original Message-----
Did you go though and change the names everywhere? They
will also need to be
changed in the query feeding the form and in the Control
Source of the bound
controls in the form. Also, is [contactID] the new or
old name?

--
Wayne Morgan
Microsoft Access MVP


message
Hello,

I'm hoping someone can help me... I have a search form
in a contact database. When someone searches for a
name
and the name appears in a listbox they should then be
able to doubleclick the name in that listbox and a more
detailed form is populated for that person. My
ondbleclick code for the listbox is:

Private Sub List22_DblClick(Cancel As Integer)

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Contact Detail"

stLinkCriteria = "[contactID]=" & Me![List22]
DoCmd.OpenForm stDocName, , , stLinkCriteria

End Sub

I recently changed the names of some of the fields in
my
underlying source table and now when I doubleclick I am
getting requests to populate parameters. I know it has
to do with me changing the names, but I can't figure
out
how to fix it. I need to keep the new names because
they
need to match the data I'm automatically importing
regularly from a text file.

Help!!

Thanks!


.

.

 

[suttoh]

BINGO!! It was the sorting of the reports!! Thank you
sooo much!

-----Original Message-----
No, you shouldn't have to change label name, they're not bound to anything.

Let's take it one step at a time. If you manually open the query feeding the
form do you get prompted? If so, the problem is probably in the query, if
not, it is further downstream (i.e. the form). If the problem is with a
report, did you check the Sorting and Grouping option?

--
Wayne Morgan
Microsoft Access MVP

I don't have to change label names do I?? I've changed
everything in all tables, forms, reports and I'm still
getting the param requests. I can't figure out what I am
missing...

-----Original Message-----
There IS someplace you've missed, it's just a matter

of
finding it. Have you

used any of the field names being requested in calculated fields in the
query, as a calculation in the control source for a control on the form, or
in a SQL statement typed directly into the row source

of
a listbox or

combobox? If you have a subform(s) on this form, is it being used as a
Master/Child join link between the main form and a subform?

--
Wayne Morgan
Microsoft Access MVP


"suttoh" <[email protected]> wrote

in
message

Contact ID is not one of the names that has changed, in
fact, it is the only one that did not change. The fields
that the params are requesting appear to be changed in
all the queries and on the form....

Any other thoughts?

Thanks.

-----Original Message-----
Did you go though and change the names everywhere? They
will also need to be
changed in the query feeding the form and in the Control
Source of the bound
controls in the form. Also, is [contactID] the new or
old name?

--
Wayne Morgan
Microsoft Access MVP


"suttoh" <[email protected]>

wrote
in

message
Hello,

I'm hoping someone can help me... I have a

search
form

in a contact database. When someone searches for a
name
and the name appears in a listbox they should

then
be

able to doubleclick the name in that listbox and

a
more

detailed form is populated for that person. My
ondbleclick code for the listbox is:

Private Sub List22_DblClick(Cancel As Integer)

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Contact Detail"

stLinkCriteria = "[contactID]=" & Me![List22]
DoCmd.OpenForm stDocName, , , stLinkCriteria

End Sub

I recently changed the names of some of the

fields
in

my
underlying source table and now when I

doubleclick
I am

getting requests to populate parameters. I know

it
has

to do with me changing the names, but I can't figure
out
how to fix it. I need to keep the new names because
they
need to match the data I'm automatically importing
regularly from a text file.

Help!!

Thanks!


.



.

.