My Intellisense Dropdown List

[Joy M]

Hi -

I have a tblInvoice with 2 fields: invTransactionCode and invPaymentCode. I
built frmInvoice from tblInvoice.

Subsequently I renamed these 2 fields in tblInvoice. The new names are:
invTransactionType and invPaymentType.

I can see these new names in tblInvoice ( I have to link to the tables
because the tables are in a separate program).
I can see them in the field list for frmInvoice. And when I click on the
propeties of the controls,
I see the new names as the control source for the controls.

But my problem is, when I use Intellisense to write code (in an event of
frmInvoice), I am still prompted for the former names
me.invTransactionCode and me.PaymentCode. The new names are not in the
Intellisense dropdown list.
Would this be normal behaviour?

Is it possible for Intellisense to find the new field names??

Thanks!

Joy

 

[Ken Snell [MVP]]

What are the names of the controls that are bound to the newly named fields?

 

[Joy M]

----- Original Message -----
From: "Ken Snell [MVP]" <[email protected]>
Newsgroups: microsoft.public.access.formscoding
Sent: Friday, November 04, 2005 5:59 PM
Subject: Re: My Intellisense Dropdown List

What are the names of the controls that are bound to the newly named
fields?

Hi Ken,

I apologize for not replying sooner.

The 2 controls are combo boxes, maybe that has something to do with it.
The intellisense still comes up with (and I quote)
Me.invTransactionCode
Me.invPaymentCode

Here are the names of the controls that are bound to the newly named field:

Name: cbo SelectTransaction
Control Source: invTransactionType
Row Source: tblTransaction

Name: cboSelectPayment
Control Source: invPaymentType
Row Source: SELECT tblPayment.payPaymentType,
tblPayment.payPaymentDescription FROM tblPayment ORDER BY [payPaymentType];

Thanks for helping,

Joy

 

[Douglas J. Steele]

Look at the RowSource for your combobox.

You need to change

Row Source: SELECT tblPayment.payPaymentType,
tblPayment.payPaymentDescription FROM tblPayment ORDER BY [payPaymentType];

to

Row Source: SELECT tblPayment.invPaymentType,
tblPayment.invPaymentDescription FROM tblPayment ORDER BY [invPaymentType];


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

----- Original Message -----
From: "Ken Snell [MVP]" <[email protected]>
Newsgroups: microsoft.public.access.formscoding
Sent: Friday, November 04, 2005 5:59 PM
Subject: Re: My Intellisense Dropdown List

What are the names of the controls that are bound to the newly named
fields?

Hi Ken,

I apologize for not replying sooner.

The 2 controls are combo boxes, maybe that has something to do with it.
The intellisense still comes up with (and I quote)
Me.invTransactionCode
Me.invPaymentCode

Here are the names of the controls that are bound to the newly named
field:

Name: cbo SelectTransaction
Control Source: invTransactionType
Row Source: tblTransaction

Name: cboSelectPayment
Control Source: invPaymentType
Row Source: SELECT tblPayment.payPaymentType,
tblPayment.payPaymentDescription FROM tblPayment ORDER BY
[payPaymentType];

Thanks for helping,

Joy

 

[Joy M]

Doug's Comment was:

Look at the RowSource for your combobox.

You need to change

Row Source: SELECT tblPayment.payPaymentType,
tblPayment.payPaymentDescription FROM tblPayment ORDER BY [payPaymentType];

to

Row Source: SELECT tblPayment.invPaymentType,
tblPayment.invPaymentDescription FROM tblPayment ORDER BY [invPaymentType];

=-=-=-=

Not sure what you are saying, Doug.

Here are the fields in tblPayment:
payPaymentType
payPaymentDescription.

(I don't have fields invPaymentType and invPaymentDescription in
tblPayment.)

Thanks,

Joy

 

[Douglas J. Steele]

Sorry, too many similar field names!

What's the RecordSource for the form? Is it a query that perhaps has the old
names in it?

 

[Joy M]

Sorry, too many similar field names!

What's the RecordSource for the form? Is it a query that perhaps has the
old names in it?

Hi Doug,

I appreciate you taking the time to help me.

The Record Source for frmInvoice is tblInvoice.
When I look at the design view of tblInvoice, I see the fields
invTransactionType and invPaymentType.

I am still wondering why Intellisense suggests me.invTransactionCode and
me.invPaymentCode.

Maybe you have some more ideas -

Joy