Enter pramater value

  • Thread starter Thread starter injanib via AccessMonster.com
  • Start date Start date
I

injanib via AccessMonster.com

hey all.

My form "Customer" is based on a table called "Main" and it had three fields
"Name", "Floor" and "Location".
I simply use the form to add new entries in the table. There are a few
buttons that perform search, delete, and other VBAs and also a combo box from
where I select a name to filter the form for that name.

I had everything working fine on this form untill I encountered a problem
with the word "Name" being a reserved Access word. This issue rose in another
form where I used the table as a record source. So I had to change the field
"Name" to "txtName". Now every time I open the form "Customer" I get a dialog
box asking for a parameter value. I have changed all the expressions in the
VBA for this form that included the word "Name" to "txtName". I can't figure
out why I still get this dialog box. It is asking for parameter value for
"Main.Name"
 
injanib said:
My form "Customer" is based on a table called "Main" and it had three fields
"Name", "Floor" and "Location".
I simply use the form to add new entries in the table. There are a few
buttons that perform search, delete, and other VBAs and also a combo box from
where I select a name to filter the form for that name.

I had everything working fine on this form untill I encountered a problem
with the word "Name" being a reserved Access word. This issue rose in another
form where I used the table as a record source. So I had to change the field
"Name" to "txtName". Now every time I open the form "Customer" I get a dialog
box asking for a parameter value. I have changed all the expressions in the
VBA for this form that included the word "Name" to "txtName". I can't figure
out why I still get this dialog box. It is asking for parameter value for
"Main.Name"
Click to expand...


Did you check for a control bound to the field?

Actually, for a form, it's most likely in the field list for
the form's record source query or in a combo/list box's
RowSource query.
 
hey all.

My form "Customer" is based on a table called "Main" and it had three fields
"Name", "Floor" and "Location".
I simply use the form to add new entries in the table. There are a few
buttons that perform search, delete, and other VBAs and also a combo box from
where I select a name to filter the form for that name.

I had everything working fine on this form untill I encountered a problem
with the word "Name" being a reserved Access word. This issue rose in another
form where I used the table as a record source. So I had to change the field
"Name" to "txtName". Now every time I open the form "Customer" I get a dialog
box asking for a parameter value. I have changed all the expressions in the
VBA for this form that included the word "Name" to "txtName". I can't figure
out why I still get this dialog box. It is asking for parameter value for
"Main.Name"
Click to expand...

You still have a reference somewhere referring to the "Name" field.
You just need to keep looking for it.
Usually overlooked is a report's Sorting and Grouping dialog.
 
Back
Top