Enter Parameter Value

[tjones]

I went though my database table and removed all spaces from the field names inside the tables. Now when I attempt to open a form the key field 790ID that used to have a space 790 ID shows in the Enter Parameter Value message that opens when choosing the button to open the child form. How do I reconnect these so that don't open the message? I have tried going to the field and changing the values in the property sheet to 790ID without the spaces but they still pop the message.

 

[bob fitz]

I have tried going to the field and changing the values in the property sheet to 790ID without the spaces

Could it be that you have changed the "Name" property of the control? You need to change the "Control Source" property.

 

[tjones]

I changed both the name and the control source, which is why it is for frustrating.

 

[bob fitz]

Is the form bound to a query. Perhaps the field names need to be changed there as well.

 

[tjones]

When I changed the table from 790 ID to 7890ID it changed most of the form and query to match. I have changed it everywhere I can find that it did not and still getting the message.
I am ready to just go back and use the old database with the space in the names as it was working, but read that to "normalize" a database there should not be any spaces.

 

[delikedi]

are there any subforms on the problematic form? or listboxes and comboboxes? in subform configurations "link master fields" may be unchanged. the same goes for the queries that lie underneath combos or listboxes, though you say that you have inspected them.

another solution may be tried with the "database documenter". Use that tool to document every possible property of every object to a pdf file. then open that file and search the term "790 ID" (with space).

 

[bob fitz]

How about in the Row Source property of a combo box or list box?

The following statements are made without any great conviction. In other words, I could be wrong.
I believe that "Normalization" is more to do with table structure. What tables you have and what fields you have in them.
I would also advise you to remove spaces from field names, but I'm not sure what problems they produce if you remember to enclose them in square brackets [].

 

[tjones]

There are no subforms, there are combo but they are working correctly and still opening the drop down list like they should. I went through the documentor for both the parent form and the child form and still can not find where it is.

 

[tjones]

OK so it is saying that in the "INDEXES" that it still says 790 ID. how do i fix the index?

 

[bob fitz]

OK so it is saying that in the "INDEXES" that it still says 790 ID. how do i fix the index?

Where and when does it say this?

May be this would help:http://office.microsoft.com/en-us/a...mdb-HP005187565.aspx?CTT=5&origin=HP001051047

 

[tjones]

Yeah! finally located the source using the documentor. in the ON CLICK macro for the button! the macro still had 790 ID.

Thanks for all the help.